Re: Querying for related tables

[Richard Huxton <dev@xxxxxxxxxxxx>]

Craig wrote:
> Hi
>  
> How can I query for all the tables that are referenced by a particular 
> table (i.e my table has 3 foreign keys. I need a query that will return 
> the table names of the referenced tables)?

See the chapters on the "Information Schema" (which is an SQL standard) 
and the "system catalogs" (which are PostgreSQL specific).

--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend