Re: How to identify which column in a table is the primary key

"Scot L. Harris" <webid@cfl.rr.com> writes:
> So given the table name is there a way to identify the column defined as
> the primary key for that table?

You need to look in pg_index.

Note that the primary key could be a multicolumn index, so starting with
the assumption that there is "the column" is going to lead you on the
wrong track.

            regards, tom lane