Re: how to save primary key constraints

pg_catalog table does not exist.

This is a solution for PostgreSQL 8.4.

If you know of a way I can get all primary key fields or have a query
that will work in 8.4, please help.  I have done a lot of research and
cannot find a simple way.


J.V.

On 10/11/2011 3:29 PM, John R Pierce wrote:
> On 10/11/11 2:16 PM, J.V. wrote:
>> I need to be able to query for all primary keys and save the table
>> name and the name of the primary key field into some structure that I
>> can iterate through later.
>>
>> How would I go about this?  I want to hard code the number of tables
>> and be able to iterate through some structure to get the table name
>> and the primary key field.
>
> that info is all in pg_catalog... pg_tables is a view of all tables...
> if you left join that with pg_index qualified by indisprimary, you'll
> probably get what you need.  you'll probably need to join pg_namespace
> to get the index name from its oid.
>
>
>