List of FKeys ?

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: List of FKeys ?
Date: 2007-08-26 23:35:50
Message-ID: 46D20E56.10101@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2007-08-27 00:11:58 Re: Block size with pg_dump?
Previous Message Jean-David Beyer 2007-08-26 21:35:15 Block size with pg_dump?