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.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
