Postgres Pro
Downloads
Home   >   mailing lists

Re: Can I drop a NOT NUL constrain on an existing table? - Mailing list pgsql-general

From Justin
Subject Re: Can I drop a NOT NUL constrain on an existing table?
Date
Msg-id CALL-XePKmdChTV-gu-=Gm5O1oNACtAb90W4G9CdHGTYYKpmHfA@mail.gmail.com
Whole thread Raw
In response to Can I drop a NOT NUL constrain on an existing table?  (stan <stanb@panix.com>)
List pgsql-general
Tree view

Alter table mytable drop constraint  name_of_constraint


On Thu, Jan 16, 2020 at 9:43 AM stan <stanb@panix.com> wrote:
I see how to do this if it is a "dcleared" constraint, but this was just
defined in the table createion as inL

 report_no                   varchar UNIQUE ,


--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                                                -- Benjamin Franklin


pgsql-general by date:

Previous
From: Justin
Date:
Subject: Re: Can I do this?
Next
From: Michael Nolan
Date:
Subject: Re: Can I do this?