Re: How to ALTER COLUMN to set a constraint of not null?

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