Re: removing fields

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