Re: Query FKey Constraint Table and Column Names

Ian Harding <iharding@tpchd.org> writes:
> Is there already a view/function that will get me this info, and if not,
> am I barking up the right tree here?

I'd suggest using pg_get_constraintdef() to decipher the contents of the
pg_constraint row.

(In 7.3 I think this function only handles foreign-key constraints, but
that's what you wanted anyway...)

            regards, tom lane