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 по дате отправления:

Предыдущее
От: "Ian Harding"
Дата:
Сообщение: Re: Categories and Sub Categories (Nested)
Следующее
От: "Shoaib Mir"
Дата:
Сообщение: problem while adding a column