Postgres Pro
Downloads
Home   >   mailing lists

Re: Querying for related tables - Mailing list pgsql-general

From Richard Huxton
Subject Re: Querying for related tables
Date
Msg-id 436A4494.9080903@archonet.com
Whole thread Raw
In response to Querying for related tables  ("Craig" <postgresql@bryden.co.za>)
Responses Re: Querying for related tables  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: how to emit line number in a function?
Next
From: Bricklen Anderson
Date:
Subject: Re: how to emit line number in a function?