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