Re: delete columns from table! - Mailing list pgsql-general

On Mon, Aug 06, 2001 at 05:42:09PM +0200, Fariba Noorbakhsh wrote:
> Hi Patrick,
>
> Do you know how I can drop(delete) a column from a table?! Just a column. I don't
> think you can do it with Alter table
>
> Thanks in advance,
> Fariba

According to the TODO list:

COMMANDS
...
* ALTER
...
    o Add ALTER TABLE DROP COLUMN feature [drop]


so the way forward may be to
pg_dump -t your_table -D your_database > table.txt
and have fun editing out all reference to said column from table.txt. Then
drop the table and reload from table.txt. YMMV..

Cheers,

Patrick