Obtaining primary key information from pg system tables

Поиск
Список
Период
Сортировка
От Kris
Тема Obtaining primary key information from pg system tables
Дата
Msg-id 009201c219d7$c6605420$30267bd5@graveland
обсуждение исходный текст
Список pgsql-sql
Дерево обсуждения
Hi,
 
I am trying to generate some xml metadata from the pg system tables for my java code generation utility. I have can get most information, but i would like to be able to tell which column is a primary key or which one is a foreign key (i dont need to know which table the foreign key references at this point).
 
Which tables do i need reference, could anyone provide an example query?
 
Kris

В списке pgsql-sql по дате отправления:

Предыдущее
От: Andrew Hammond
Дата:
Сообщение: Re: is it easy to change the create sequence algorithm?
Следующее
От: "Dmitri Colebatch"
Дата:
Сообщение: Re: Obtaining primary key information from pg system tables