On Mon, Sep 19, 2011 at 8:34 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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.)
OK. Thanks all.
--patrick