Re: locating a primary key

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: locating a primary key
Дата
Msg-id 6596.1145503128@sss.pgh.pa.us
обсуждение исходный текст
Ответ на locating a primary key  (Orion <lab@orangekids.org>)
Список pgsql-general
Orion <lab@orangekids.org> writes:
> I'm trying to craft a query that will determine what column(s) belong
> to the primary key for a given table.

The information_schema.key_column_usage view might help.

> This is all due to the use of
> the int2vect type on indkey which is undocumented and does not seem to
> work with normal array tools such as ANY and cant be cast to int2[].

As of 8.1 it can ...

            regards, tom lane

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