Re: Foreign Key Identification

Поиск
Список
Период
Сортировка
От A. Kretschmer
Тема Re: Foreign Key Identification
Дата
Msg-id 20070110174104.GA23165@a-kretschmer.de
обсуждение исходный текст
Ответ на Re: Foreign Key Identification  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Foreign Key Identification  (Reece Hart <reece@harts.net>)
Список pgsql-general
am  Wed, dem 10.01.2007, um 12:17:25 -0500 mailte Tom Lane folgendes:
> "A. Kretschmer" <andreas.kretschmer@schollglas.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: index creation on 7.3
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Advice needed on using postgres in commercial product