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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
