Re: Alter table column constraint

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Alter table column constraint
Date: 2018-12-17 20:01:49
Message-ID: alpine.LNX.2.20.1812171201160.741@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2018-12-17 20:06:50 Re: Alter table column constraint
Previous Message Rich Shepard 2018-12-17 19:58:54 Alter table column constraint