List of FKeys ? - Mailing list pgsql-sql

From Andreas
Subject List of FKeys ?
Date
Msg-id 46D20E56.10101@gmx.net
Whole thread Raw
Responses Re: List of FKeys ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Hi,

could I get a list of foreign keys that refer to a column?

Say I have a  table_1 (t1_id integer ......)
and a lot of other tables that may refer to table 1.

Is there a command that lists all tables that have a foreign key that 
points to  t1_id?
Preferably with the "on update/delete" options of the relation.


Regards
Andreas


pgsql-sql by date:

Previous
From: Jean-David Beyer
Date:
Subject: Block size with pg_dump?
Next
From: Bruce Momjian
Date:
Subject: Re: Block size with pg_dump?