Thread: Querying for related tables

Querying for related tables

From
"Craig"
Date:
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)?
 
Thanks
Craig

Re: Querying for related tables

From
Richard Huxton
Date:
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

Re: Querying for related tables

From
"Jim C. Nasby"
Date:
On Thu, Nov 03, 2005 at 05:10:44PM +0000, Richard Huxton wrote:
> 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).

See also http://pgfoundry.org/projects/newsysviews
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461