Querying for related tables
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
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
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