AFAIK, right now all you can do is use pg_trigger and that is how pg_dump
is reading the constraint information.
On Mon, 13 Nov 2000, Jason Davies wrote:
> Hi,
>
> Sorry if this is a re-post. Could someone tell me how I can list the foreign
> key info for a given column or for a given table?
>
> All I want is the information about the relationships for a specified column.
> The best I've come up with so far is looking in the pg_trigger table, but this
> is not ideal. There must be a way, because pg_dump gets the relationships
> somehow.