On Tue, 2003-01-14 at 04:47, Peter Gibbs wrote:
> Jean-Christian Imbeault wrote:
> > How does one add a "NOT NULL" constraint to a new column?
> ALTER TABLE [ ONLY ] table [ * ]
> ALTER [ COLUMN ] column { SET | DROP } NOT NULL
Note that using ALTER TABLE to make a column NOT NULL is fully supported
as of PostgreSQL 7.3 -- since the idocs are still from 7.2, they are
correct when they say there's no way to do it (using ALTER TABLE).
Cheers,
Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
