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

From Rene Pijlman
Subject Re: querying system catalogs to extract foreign keys
Date
Msg-id 4fj4qtsrv8sc0potbbs3dpd8i3skmrnemd@4ax.com
Whole thread Raw
In response to querying system catalogs to extract foreign keys  (jiby@intelesoftech.com (jiby george))
List pgsql-hackers
On 13 Sep 2001 22:56:16 -0700, you wrote:
>I tried to use the getImportedKeys and getExportedKeys of 
>java.sql.DatabaseMetadata... But it didnt give any expected 
>results... 

This is probably a limitation or bug in the JDBC driver. Please
post details of your problem on pgsql-jdbc@postgresql.org. E.g.
what results did you get, and what did you not get?

>So can anyone tell me how to query the system
>catalogs to extract this info??

The system catalogs are documented on
http://www.postgresql.org/idocs/index.php?catalogs.html

Regards,
René Pijlman <rene@lab.applinet.nl>


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: syslog by default?
Next
From: "Jim Buttafuoco"
Date:
Subject: Status of index location patch