Re: querying system catalogs to extract foreign keys

From: Rene Pijlman <rene(at)lab(dot)applinet(dot)nl>
To: jiby(at)intelesoftech(dot)com (jiby george)
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: querying system catalogs to extract foreign keys
Date: 2001-09-14 18:38:01
Message-ID: 4fj4qtsrv8sc0potbbs3dpd8i3skmrnemd@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)postgresql(dot)org(dot) 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(at)lab(dot)applinet(dot)nl>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Gould 2001-09-14 18:40:00 Re: count of occurences
Previous Message Matthew Rice 2001-09-14 16:06:20 Re: Where do they find the time??? Great Bridge closed now!!!??