SQL Query to get Column constraints

Поиск
Список
Период
Сортировка
От Steve
Тема SQL Query to get Column constraints
Дата
Msg-id Msrha.2149$ft3.12066@news-server.bigpond.net.au
обсуждение исходный текст
Ответы Re: SQL Query to get Column constraints
Список pgsql-hackers
Hi there,

I have been through  the postgres faq's, and read through the describe.c
file.

I can't seem to solve my problem.

I am building an automatic file writer, that gives me information about each
of my tables.

What I need to know, is how to find out if a column is a primary, or part of
a primary key.  I need to do this using sql.

I am used to oracle, whose structure is different. Can anyone help me.

Whiel I am at it, If I can dynamically find out if a column has a sequence
attached to it, that would also be useful.

Regards

Steve



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

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Re: 7.4devel auth failed
Следующее
От: Olleg Samojlov
Дата:
Сообщение: Re: Changing behavior of BEGIN...sleep...do something...COMMIT