Re: Foreign Keys - Mailing list pgsql-general

From Tom Lane
Subject Re: Foreign Keys
Date
Msg-id 26440.995402866@sss.pgh.pa.us
Whole thread Raw
In response to Re: Foreign Keys  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> How can you get a listing of foreign keys to a table?

> We haven't figure out a good way yet.

You can figure it out by rooting through pg_triggers looking for RI
triggers that reference your table ... but of course this is pretty
painful and ugly.  Sometime we should build a view to do it for you.

            regards, tom lane

pgsql-general by date:

Previous
From: wsheldah@lexmark.com
Date:
Subject: Re: undeleteable records
Next
From: will trillich
Date:
Subject: Re: editor with syntax-highlighting for PL/PGSQL