On Wed, 4 Oct 2000, Andrew Gould wrote:
> How do you drop a column from a table? I'm using
> PostgreSQL 7.0.2.
From the FAQ.
4.5) How do you remove a column from a table?
We do not support ALTER TABLE DROP COLUMN, but do this:
SELECT ... -- select all columns but the one you want to remove
INTO TABLE new_table
FROM old_table;
DROP TABLE old_table;
ALTER TABLE new_table RENAME TO old_table;
Thank you,
Jason C. Wells
