Re: Dynamic constraint names in ALTER TABLE - Mailing list pgsql-general

patrick keshishian <pkeshish@gmail.com> writes:
> The question wasn't where does one find the name of the constraint. My
> example demonstrated that I knew how to get that value. The question,
> however, is how do you get that in an ALTER TABLE statement?

You'd need to construct the ALTER statement as a string value and then
EXECUTE it, using a plpgsql function.  (In 9.0 you could use a DO
command, but if you want this to also work in 7.4, it'll have to be a
plain old function.)

            regards, tom lane