Re: adding fields to a table - Mailing list pgsql-general

From Benjamin Jury
Subject Re: adding fields to a table
Date
Msg-id 24DC688F52AAD611B60900096BB0B440015D82C6@chapar.mpuk.com
Whole thread Raw
In response to adding fields to a table  (MT <m_tessier@sympatico.ca>)
Responses Re: adding fields to a table  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
> > However you cannot currently remove a column...
>
> Oh yes you can:
>
> ALTER TABLE tbl DROP COLUMN whatever
>
> http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&fil
> e=ddl-alter.html
>
> IIRC it was introduced fairly recently (7.3?)

Doh! Really should get rid of 'Practical PostgreSQL' as my point of
reference, only covers 7.1.x... Come on O'Reilly, print a second edition!

pgsql-general by date:

Previous
From: u15074
Date:
Subject: Re: Is it possible to change the wal file size?
Next
From: "Nick Barr"
Date:
Subject: Re: Inherits tables and current CVS