pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedadding not null constraints on columns
2+ messages / 2 participants
[nested] [flat]
* adding not null constraints on columns
@ 2003-02-11 23:44 Susan <brknrose@counterconspiracy.org>
0 siblings, 1 reply; 2+ messages in thread
From: Susan @ 2003-02-11 23:44 UTC (permalink / raw)
To: pgsql-sql
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 - )
brknrose@counterconspiracy.org
Attachments:
ribbontsmall.gif (image/gif, 1.4K) download
view image
Cancerribbon.gif (image/gif, 271B) download
view image
AIDSribbon.gif (image/gif, 1.4K) download
view image
* Re: adding not null constraints on columns
@ 2003-02-12 06:18 Tom Lane <tgl@sss.pgh.pa.us>
parent: Susan <brknrose@counterconspiracy.org>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2003-02-12 06:18 UTC (permalink / raw)
To: Susan <brknrose@counterconspiracy.org>; +Cc: pgsql-sql
"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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-02-12 06:18 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-11 23:44 adding not null constraints on columns Susan <brknrose@counterconspiracy.org>
2003-02-12 06:18 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox