Re: Dynamic constraint names in ALTER TABLE

On Mon, Sep 19, 2011 at 8:34 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> patrick keshishian <pkeshish(at)gmail(dot)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.)

OK. Thanks all.

--patrick