Horton

Re: ehm... drop column...

D. Duccini <duccini@backpack.com>

View thread View on postgr.es
From: "D. Duccini" <duccini@backpack.com>
To: andrea gelmini <bungle@linux.it>
Cc: pgsql-novice@postgresql.org
Date: 2000-10-31T07:54:12Z
Lists: pgsql-novice 
its not really possible

best bet is to

1. rename the column to something

   oldcolumn

optionally

2. create a new table, and select into this new "clean" table, and the
drop the old one


On Tue, 31 Oct 2000, andrea gelmini wrote:

> hi all,
> 	i'm going mad trying to find a way to delete a column
> 	in a table.
> 	if i try it like in oracle, with alter, it doesn't
> 	work, and i didn't find anything in the docs...
> 	so, i'm afraid it's not possibile...
> 
> thanks for your time,
> andrea
> 


-----------------------------------------------------------------------------
david@backpack.com            BackPack Software, Inc.        www.backpack.com
+1 651.645.7550 voice       "Life is an Adventure.    
+1 651.645.9798 fax            Don't forget your BackPack!"   
-----------------------------------------------------------------------------