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