| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Foreign Key Identification |
| Date: | 2007-01-10 17:41:04 |
| Message-ID: | 20070110174104.GA23165@a-kretschmer.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
am Wed, dem 10.01.2007, um 12:17:25 -0500 mailte Tom Lane folgendes:
> "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> writes:
> > am Wed, dem 10.01.2007, um 8:23:28 -0800 mailte Ashish Karalkar folgendes:
> >> Is there any means to list out the foreign key tables
> >> which are liked with a primary key?
>
> > Take a look into the pg_depend - table.
>
> I think there's an information_schema view that would give you this
> without getting so cozy with implementation details as to look in
> pg_depend ...
I have no doubt, but unfortunately i don't know details. Can you help?
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2007-01-10 17:43:32 | Re: Advice needed on using postgres in commercial product |
| Previous Message | Scott Marlowe | 2007-01-10 17:40:27 | Re: index creation on 7.3 |