Re: Is there any way to delete a column - Mailing list pgsql-general

From Ian Barwick
Subject Re: Is there any way to delete a column
Date
Msg-id 200303101051.51436.barwick@gmx.net
Whole thread Raw
In response to Is there any way to delete a column  ("shreedhar" <shreedhar@lucidindia.net>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Jose Antonio Martinez
Date:
Subject: ems postgresql manager
Next
From: Abhishek Verma
Date:
Subject: problem :unable to use arrow keys in psql