From: | wsheldah(at)lexmark(dot)com |
---|---|
To: | Ian Barwick <barwick(at)gmx(dot)net> |
Cc: | "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 14:16:54 |
Message-ID: | OFBAC32B87.DEE6FFA9-ON85256CE5.004E603F@lexmark.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | jose antonio leo | 2003-03-10 14:26:37 | unlock Select for update |
Previous Message | Abhishek Verma | 2003-03-10 13:19:33 | problem : how to connect postgres with servlets |