Postgres Pro
Downloads
Home   >   mailing lists

querying system catalogs to extract foreign keys - Mailing list pgsql-hackers

From jiby@intelesoftech.com (jiby george)
Subject querying system catalogs to extract foreign keys
Date
Msg-id e429dc1a.0109132156.ad779c9@posting.google.com
Whole thread Raw
Responses Re: querying system catalogs to extract foreign keys  (Rene Pijlman <rene@lab.applinet.nl>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: "francis"
Date:
Subject: Trigger - Editing Procedures
Next
From: John Summerfield
Date:
Subject: Re: [BUGS] Build problem with CVS version