Postgres Pro
Downloads
Home   >   mailing lists

Finding PrimaryKey columns of a table - Mailing list pgsql-general

From swalker
Subject Finding PrimaryKey columns of a table
Date
Msg-id Pine.LNX.4.21.0005021223280.12169-100000@ct36753-a.jfrvil1.in.home.com
Whole thread Raw
Responses Re: Finding PrimaryKey columns of a table  (rmcm@compsoft.com.au)
List pgsql-general
Tree view 
Is there a query I can run against the pg system tables to figure out what
columns of the table make up the primary key?

I've messed around w/ psql -E (which is very cool btw) and can't seem to
find the exact query I'm looking for.  I can get all indexes for a table,
but I can't seem to limit the result set to only the primary key.

Am I missing something obvious ?

Thanks
Steve

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: postgresql7.0 jdbc driver
Next
From: "Michael Simcich"
Date:
Subject: Setting up PGSQL 7 on Win2K