getting primary and foreign using jdbc - Mailing list pgsql-general

From niamul@another.com
Subject getting primary and foreign using jdbc
Date
Msg-id 13462661.991401509371.JavaMail.nobody@smtp.backend.another.com
Whole thread Raw
List pgsql-general
Hi,

I am using PostgreSQL 7.1 with jdbc driver jdbc6.5-1.2.jar, I would like to get the primary and foreign key from the
database.The ResultSet returned by the jdbc is always empty. Could someone please tell me how to get the primary key
andforeign key from the postgresql. 

I specially need to know the foreign key, I tried to get it through the system catalogs by doing a sql query, but my
knowledgeof such table and how to use them is very limited. I would be very grateful if someone can send me a solution
tothis problems, especially for the foreign key. 

Many thanks.

N

-----

Be passionate about your email
Just click here: http://another.com


pgsql-general by date:

Previous
From: "Steve Wolfe"
Date:
Subject: Re: Now what?
Next
From: "Craig Orsinger"
Date:
Subject: Re: PostgreSQL security concerns