Re: where's ALTER TABLE table DROP [ COLUMN ] column???
Keith Gray <keith@heart.com.au>
From: Keith Gray <keith@heart.com.au>
To: Bruno Boettcher <bboett@erm1.u-strasbg.fr>, PostgreSQL <pgsql-sql@postgresql.org>
Date: 2001-05-25T06:30:17Z
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