Re: where's ALTER TABLE table DROP [ COLUMN ] column???

From: Keith Gray <keith(at)heart(dot)com(dot)au>
To: Bruno Boettcher <bboett(at)erm1(dot)u-strasbg(dot)fr>, PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: where's ALTER TABLE table DROP [ COLUMN ] column???
Date: 2001-05-25 06:30:17
Message-ID: 3B0DFBF9.CEBDC3CC@heart.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Larry Rosenman 2001-05-25 07:56:23 locking/concurrency question.
Previous Message Richard Huxton 2001-05-24 23:28:39 Re: photos and OID's