Re: Query FKey Constraint Table and Column Names - Mailing list pgsql-general

From Tom Lane
Subject Re: Query FKey Constraint Table and Column Names
Date
Msg-id 26348.1065197696@sss.pgh.pa.us
Whole thread Raw
In response to Query FKey Constraint Table and Column Names  (Ian Harding <iharding@tpchd.org>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Robert Wille"
Date:
Subject: Re: LC_COLLATE=C not working
Next
From: "Joshua D. Drake"
Date:
Subject: Re: administration with pgaccess