On 08/03/10 12:13 PM, George Silva wrote:
Hello guys,
I'm building a function which needs to know what is the primary key of
a certain table (all in pgplsql).
I was using select * from information_schema.key_column_usage where
table_schema='foo' and table_name = 'aaa'; but that will give me
multiple results in case of additional keys in the table.
the primary key index is called tablename_pkey ... afaik, this is the
only thing that makes it special, otherwise, its just another index with
a unique constraint.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
