> > 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! ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])