Ben Liblit <liblit(at)eecs(dot)berkeley(dot)edu> writes:
> Given a table "data" with column "value", one can add a constraint that
> has no name:
> ALTER TABLE data ADD CHECK (value > 0);
> How, then, does one remove this constraint?
The constraint *does* have a name, it's just an auto-assigned one
(probably of the form "$n"). Try psql's \d command to check out
constraint names.
regards, tom lane