On Tue, Aug 3, 2010 at 3:13 PM, George Silva <georger(dot)silva(at)gmail(dot)com> 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.
>
> Any suggestions?
take a look at information_schema.table_constraint and match on constraint_name.
merlin