Re: where's ALTER TABLE table DROP [ COLUMN ] column??? - Mailing list pgsql-sql

From Keith Gray
Subject Re: where's ALTER TABLE table DROP [ COLUMN ] column???
Date
Msg-id 3B0DFBF9.CEBDC3CC@heart.com.au
Whole thread Raw
In response to where's ALTER TABLE table DROP [ COLUMN ] column???  (bboett@erm1.u-strasbg.fr (Bruno Boettcher))
List pgsql-sql
Bruno Boettcher wrote:
> 
> Hello!
> 
> as far as i can tell, i can add columns to a table, but can't remove
> them later on.....
> 
> is this true? 

My thought would be that somebody must have written an 
automated version of 

select [all columns except named] from [named table] into droptemp;
drop [named table];
select * from droptemp into [named table];

Would this be available or easily written as a "rule" ??
Could anyone familiar with the code comment?

-- 
Keith Gray


pgsql-sql by date:

Previous
From: "Richard Huxton"
Date:
Subject: Re: photos and OID's
Next
From: Larry Rosenman
Date:
Subject: locking/concurrency question.