From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | "Krog, Kenneth" <KAKrog(at)MassMutual(dot)com> |
Cc: | "PostgreSQL general list (E-mail)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Dropping Fields In A Table |
Date: | 2001-09-17 15:18:03 |
Message-ID: | Pine.BSF.4.21.0109170816080.57838-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 17 Sep 2001, Krog, Kenneth wrote:
> Thanks for the response to the last question, and also please let me know if
> these questions are going to the right group, you all seem alot better than
> these questions.
>
> In what version of Postgre are you able to drop fields in a table (7.1?),
> and is this the correct syntax:
> ALTER TABLE tablename DROP COLUMN columnname;
>
> And is their a way to change the type of column that a column is for
> instance from CHAR to INT, and what is the syntax for that. I looked up one
> side of the documentation and down the other and their does not seem to be a
> way.
IIRC, The only way currently for both of these is to do something like:
create the new table and do something like insert into ... select
to move the data and then drop the old table and rename the new one into
place.
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2001-09-17 15:19:06 | Re: adding a superuser |
Previous Message | Cosmos Tong | 2001-09-17 15:14:08 | Error in compiling PHP with PostgreSQL support |