How do I list foreign key info/relationships?

From: Jason Davies <jason_ddavies(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How do I list foreign key info/relationships?
Date: 2000-11-13 12:39:08
Message-ID: 20001113123908.33256.qmail@web218.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wouter Tijhuis 2000-11-13 12:58:06 Multiple Inheritance
Previous Message Roger Wernersson 2000-11-13 11:26:54 RE: Sequences in transaction