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.) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
