Skip site navigation (1) Skip section navigation (2)

Re: delete column

From: "Hillensbeck, Preston" <PHillensbeck(at)sfbcic(dot)com>
To: 'webmaster' <webmaster(at)harbornet(dot)com>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: delete column
Date: 2002-04-26 20:49:49
Message-ID: 040AE3A029B3D51181D000508BC75D02013877E6@MERCURY (view raw, whole thread or download thread mbox)
Lists: pgsql-general
There isn't a DROP COLUMN function yet, but you can do this...

SELECT ... -- select all columns but the one you want to remove
INTO TABLE new_table
FROM old_table;
DROP TABLE old_table;
ALTER TABLE new_table RENAME TO old_table;

This is straight out of Bruce Momjian's book, so you can give him credit for
this :)

-----Original Message-----
From: webmaster [mailto:webmaster(at)harbornet(dot)com]
Sent: Friday, April 26, 2002 7:51 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] delete column

I know this is an easy question, but I can't find any info on how do
this in the PostgreSQL book.  How do you delete a column?  I've been
able to delete tables, db's, rows, etc.  But can't figure out how to
just delete a column.  I'm running RedHat 7.2 and PostgreSQL 7.1

Thanks for any help.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org


pgsql-general by date

Next:From: wsheldahDate: 2002-04-26 20:54:25
Subject: Re: delete column
Previous:From: Bruce MomjianDate: 2002-04-26 20:30:17
Subject: Re: [GENERAL] Auth problem in pg_hdba.conf

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group