On Mon, Sep 19, 2011 at 8:34 PM, Tom Lane <[email protected]> wrote: > patrick keshishian <[email protected]> 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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
