Re: [HACKERS] Finding primary keys in a table

Поиск
Список
Период
Сортировка
От darcy@druid.net (D'Arcy J.M. Cain)
Тема Re: [HACKERS] Finding primary keys in a table
Дата
Msg-id m0yyLLH-00006FC@druid.net
обсуждение исходный текст
Ответ на Re: [HACKERS] Finding primary keys in a table  (Bruce Momjian <maillist@candle.pha.pa.us>)
Ответы Re: [HACKERS] Finding primary keys in a table
Список pgsql-hackers
Thus spake Bruce Momjian
> > Can someone suggest a SQL statement to pull out the primary key(s) from
> > a table?
> Because we just create a unique index on a PRIMARY specification, I
> think any unique index on a field shows it as primary.

Hmm.  Any chance we can somehow flag it as well?  Perhaps a new bool
field in pg_index the next time we do a dump & reload release?  I
assume we will need it eventually anyway.

--
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] s_lock.h busted
Следующее
От: dg@illustra.com (David Gould)
Дата:
Сообщение: Re: [HACKERS] s_lock.h busted