| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | <tij(at)jhb(dot)ucs(dot)co(dot)za> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: List Foreign Key Relationships |
| Date: | 2002-10-04 15:42:05 |
| Message-ID: | 20021004084105.C36970-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2 Oct 2002, Tim Jones wrote:
> Hi All
>
> I am try to query the dictionary to get a list of the foreign key
> relationships in the dictionary.
> Say in the form Primary Key Table, Primary Column(s), Foreign Key Table,
> Foreing Key Column(s)
> Any ideas. I suppose I could try and unpack the bytea in pg_trigger. Any
> other ideas?
Fortunately other people have already done that. I believe one of the
documents on techdocs.postgresql.org goes into it or failing that it's
possible there's something in the PostgreSQL cookbook (which should also
be linked to by techdocs)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2002-10-04 15:49:38 | Re: psql scripts |
| Previous Message | scott.marlowe | 2002-10-04 15:42:02 | Re: SERIAL with TTable in cbuilder |