Re: Alter table column constraint - Mailing list pgsql-general

From Rich Shepard
Subject Re: Alter table column constraint
Date
Msg-id alpine.LNX.2.20.1812171201160.741@salmo.appl-ecosys.com
Whole thread Raw
In response to Alter table column constraint  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Alter table column constraint
List pgsql-general
On Mon, 17 Dec 2018, Rich Shepard wrote:

> I want to alter a term in a column's constraint to allow only specified
> strings as attributes and have not found how to do this in the docs (using
> version 10 docs now). There is an alter table command that allows renaming
> a constraint but I've not seen how to modify the constraint itself.

   Is the procedure to drop the current check constraint then add the revised
one?

Rich


pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Alter table column constraint
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Alter table column constraint