Thread: How do I list foreign key info/relationships?

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.

I would be grateful for any suggestions,
Jason Davies

=====
Jason Davies,

 _  _ _|_ _ _  _  _| _    | www.netspade.com
| |(/_ | _\|_)(_|(_|(/_   | programming tutorials
           |              | programming community
-----------------------   | programming news

__________________________________________________
Do You Yahoo!?
Yahoo! Calendar - Get organized for the holidays!
http://calendar.yahoo.com/

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.