Thread: removing fields
Does version 7.2 of Postgresql allow us to remove a column from a table? It does not appear to be working but I may be getting the syntax wrong. I thought this was a feature that was going to be added??
Thanks
Jodi
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu
Not in 7.2, but it's in 7.3(beta). HTH... -----Original Message----- From: Jodi Kanter [mailto:jkanter@virginia.edu] 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? It does not appear to be working but I may be gettingthe syntax wrong. I thought this was a feature that was going to be added?? Thanks Jodi _______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 jkanter@virginia.edu
On Wed, Sep 25, 2002 at 10:34:47AM -0400, Jodi Kanter wrote:
> Does version 7.2 of Postgresql allow us to remove a column from a
> table?
No.
> syntax wrong. I thought this was a feature that was going to be
> added??
Yes. 7.3.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
Yoou could do the following:
SELECT list_of_all_columns_you_want_to_keep
INTO TABLE new_table
FROM old_table;
DROP TABLE old_table;
ALTER TABLE new_table RENAME TO old_table;
I saw this in Bruce Momjian'n book "PostgreSQL Introduction and Concepts".
Regards
Devinder Rajput
Stores Division Corporate Offices
Chicago, IL
(773) 442-6474
Andrew Sullivan
<andrew@libertyrms.inf To: Postgres Admin List <pgsql-admin@postgresql.org>
o> cc:
Sent by: Subject: Re: [ADMIN] removing fields
pgsql-admin-owner@post
gresql.org
09/25/2002 01:41 PM
On Wed, Sep 25, 2002 at 10:34:47AM -0400, Jodi Kanter wrote:
> Does version 7.2 of Postgresql allow us to remove a column from a
> table?
No.
> syntax wrong. I thought this was a feature that was going to be
> added??
Yes. 7.3.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org