querying system catalogs to extract foreign keys

From: jiby(at)intelesoftech(dot)com (jiby george)
To: pgsql-hackers(at)postgresql(dot)org
Subject: querying system catalogs to extract foreign keys
Date: 2001-09-14 05:56:16
Message-ID: e429dc1a.0109132156.ad779c9@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wanted to extract foriegn keys from the postgresql database related
to each of the tables.. I tried to use the getImportedKeys and
getExportedKeys of java.sql.DatabaseMetadata... But it didnt give any
expected results... So can anyone tell me how to query the system
catalogs to extract this info??
Thanx
Jiby

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2001-09-14 06:38:00 Re: count of occurences PLUS optimisation
Previous Message peace_flower 2001-09-14 01:57:34 Where do they find the time??? Great Bridge closed now!!!??