Postgres Pro
Downloads
Home   >   mailing lists

Thread: adding not null constraints on columns

adding not null constraints on columns

From
"Susan"
Date:
Is there a way to add not null constraints on a column after the column has been created?  Any help would be appreciated.  Thanks.
 
The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents.
Nathaniel Borenstein (1957 - )
 
 
Attachment

Re: adding not null constraints on columns

From
Tom Lane
Date:
"Susan" <brknrose@counterconspiracy.org> writes:
> Is there a way to add not null constraints on a column after the column
> has been created?  Any help would be appreciated.  Thanks.

Certainly.  See the ALTER TABLE command.
        regards, tom lane