Postgres Pro
Downloads
Home   >   mailing lists

how do I get the primary key - Mailing list pgsql-general

From Rick Gigger
Subject how do I get the primary key
Date
Msg-id 002d01c3d6f4$18074600$0700a8c0@trogdor
Whole thread Raw
Responses Re: how do I get the primary key
List pgsql-general
Tree view 
I am creating a script to dump a postgres database into a sqlite database.
I need to know how to find out programattically what fields are in the
primary key of a given table.  Is this possible in postgres?

Thanks,

Rick

pgsql-general by date:

Previous
From: Amir Khawaja
Date:
Subject: OIDS and its limitations
Next
From: Bob.Henkel@hartfordlife.com
Date:
Subject: what we need to use postgresql in the enterprise