Re: Can I drop a NOT NUL constrain on an existing table?

[Justin <zzzzz.graf@xxxxxxxxx>]

Alter table mytable drop constraint  name_of_constraint

https://www.postgresql.org/docs/current/sql-altertable.html

On Thu, Jan 16, 2020 at 9:43 AM stan <stanb@xxxxxxxxx> 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