Not in 7.2, but it's in 7.3(beta).
HTH...
-Original Message-
From: Jodi Kanter [mailto:[EMAIL PROTECTED]]
Sent: Wed 9/25/2002 9:34 AM
To: Postgres Admin List
Cc:
Subject:[ADMIN] removing fields
Does version 7.2 of Postgresql allow us to remove a column from a table?
As we transition our database, I'm finding the need to change columns
types. I'm also finding this to be a major PITA.
I have a column that's a something like:
create table stuff
(
...
rate varchar(7),
...
);
However that doesn't allow math-like functions (e.g. avg), so it's gotta
be chang
Luis Felipe Acevedo Fernandez wrote:
> Hi!
> I triyed to migrate a database from SqlServer to PostgreSql, but I have a
> problem with char or varchar data types cos If I try to insert or select some
> information from a table the program retrieve blank spaces, my program was
> develop in PowerB
Bruce Momjian wrote:
> Kevin Brannen wrote:
>
>>Bruce Momjian wrote:
>>...
>>
>>>7.3 may remove PGPASSWORD, I think, and instead allow you to specify a
>>>file that contains the password.
>>
>>But do you know how many hours it took me to fin
Bruce Momjian wrote:
...
>
> 7.3 may remove PGPASSWORD, I think, and instead allow you to specify a
> file that contains the password.
But do you know how many hours it took me to find out about PGPASSWORD
in the docs and now you want to change that? :-)
How about all 4 approaches: on the com
Michael A. Schulte wrote:
> Hi,
>
> does anyone have an idea how to convince psql
> to accept a password that is passed during startup
> of psql in the command line?
>
> I don't want to modify pg_hba.conf so that it
> is open for everyone so I have inserted:
>
> local all
Guthrie, John wrote:
> keep in mind that cronjobs don't get your login environment, so things that
> work in interactive mode often fail in cron unless you make sure to set up
> the environment there too.
That is very important to remember! First try adding "< /dev/null" to
the command. If tha
