Re: [HACKERS] Finding primary keys in a table - Mailing list 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.