Thread: Finding all References to a Primary Key

I'm sorry if this is has been discussed, but I tried to find the answer 
in the archives and failed, so...

How do I find all the rows in other tables that reference a specific row 
in another table?  I'm only trying to find rows that are in tables where 
there is a Foreign Key referencing the primary key of the table in question.

Example:
Table People has a primary key of people_id
There are say 20 tables that have foreign keys referencing people.people_id
How do I find all the rows in all of those 20 tables that reference a 
particular person in the people table?


Thank you in advance,

Matthew O'Connor

On Mar 26, 2008, at 1:19 PM, Matthew T. O'Connor wrote:
> I'm sorry if this is has been discussed, but I tried to find the
> answer in the archives and failed, so...
>
> How do I find all the rows in other tables that reference a specific
> row in another table?  I'm only trying to find rows that are in
> tables where there is a Foreign Key referencing the primary key of
> the table in question.
>
> Example:
> Table People has a primary key of people_id
> There are say 20 tables that have foreign keys referencing
> people.people_id
> How do I find all the rows in all of those 20 tables that reference
> a particular person in the people table?

pg_catalog.pg_constraint has that info.

Erik Jones

DBA | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com