Re: Is there any way to delete a column

From: Ian Barwick <barwick(at)gmx(dot)net>
To: "shreedhar" <shreedhar(at)lucidindia(dot)net>, "Postgre General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is there any way to delete a column
Date: 2003-03-10 09:51:51
Message-ID: 200303101051.51436.barwick@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Abhishek Verma 2003-03-10 10:06:24 problem :unable to use arrow keys in psql
Previous Message Jose Antonio Martinez 2003-03-10 09:32:46 ems postgresql manager