On Mon, Sep 19, 2011 at 8:34 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > patrick keshishian <pkeshish@xxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
