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.