Search Postgresql Archives

Re: how to save primary key constraints

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux