Is there any way to delete a column

From: "shreedhar" <shreedhar(at)lucidindia(dot)net>
To: "Postgre General" <pgsql-general(at)postgresql(dot)org>
Subject: Is there any way to delete a column
Date: 2003-03-10 09:13:55
Message-ID: 006d01c2e6e5$60285370$1201a8c0@a4005
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Regards,
Sreedhar

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jose Antonio Martinez 2003-03-10 09:32:46 ems postgresql manager
Previous Message shreedhar 2003-03-10 09:07:43 Re: PostgreSQL Frontend for Windows