In 7.3.x,
ALTER TABLE DROP COLUMN column_name
Ian Barwick <barwick@gmx.net>@postgresql.org on 03/10/2003 04:51:51 AM
Sent by: pgsql-general-owner@postgresql.org
To: "shreedhar" <shreedhar@lucidindia.net>, "Postgre General"
<pgsql-general@postgresql.org>
cc:
Subject: Re: [GENERAL] Is there any way to delete a column
On Monday 10 March 2003 10:13, shreedhar wrote:
> To delete a column from table , I am following the method as per
postgresl
> documents.
>
> 1) creating emptable with same structure and moving all records.
> 2) creating another table with out column which you have remove.
> 3) Creating all constraints.
> 4) moving all data from temp table to new table and removing temp table.
>
> Is there any way to delete a column, other than above method
Upgrade to 7.3 :-)
Ian Barwick
barwick@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html