On Thursday 26 June 2003 18:34, Benjamin Jury wrote:
(...)
>
> You can use ALTER TABLE.
>
> ALTER TABLE <table> ADD [column] column type
>
> Can also rename columns, add constraints, change to NOT NULL, etc.
>
> 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&file=ddl-alter.html
IIRC it was introduced fairly recently (7.3?)
Ian Barwick
barwick(at)gmx(dot)net