| 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: | Whole Thread | Raw Message | 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/
| 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 |