Re: Is there any way to delete a column

In 7.3.x,
ALTER TABLE DROP COLUMN column_name

Ian Barwick <barwick(at)gmx(dot)net>@postgresql.org on 03/10/2003 04:51:51 AM

Sent by: pgsql-general-owner(at)postgresql(dot)org

To: "shreedhar" <shreedhar(at)lucidindia(dot)net>, "Postgre General"
<pgsql-general(at)postgresql(dot)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(at)gmx(dot)net

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html