Thread

Re: Is there any way to delete a column

wsheldah@lexmark.com — 2003-03-10T14:16:54Z

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