Re: Foreign Key Identification

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Foreign Key Identification
Date: 2007-01-10 17:17:25
Message-ID: 10099.1168449445@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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 ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-01-10 17:40:27 Re: index creation on 7.3
Previous Message Brad Nicholson 2007-01-10 16:58:02 Re: Recording insert, updates, and deletes