getting primary and foreign using jdbc

Поиск
Список
Период
Сортировка
От niamul@another.com
Тема getting primary and foreign using jdbc
Дата
Msg-id 13462661.991401509371.JavaMail.nobody@smtp.backend.another.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Steve Wolfe"
Дата:
Сообщение: Re: Now what?
Следующее
От: "Craig Orsinger"
Дата:
Сообщение: Re: PostgreSQL security concerns