Re: adding fields to a table

From: Benjamin Jury <benjamin(dot)jury(at)mpuk(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: adding fields to a table
Date: 2003-06-27 08:53:38
Message-ID: 24DC688F52AAD611B60900096BB0B440015D82C6@chapar.mpuk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nick Barr 2003-06-27 09:16:59 Re: Inherits tables and current CVS
Previous Message u15074 2003-06-27 08:30:19 Re: Is it possible to change the wal file size?