On Tue, Aug 3, 2010 at 3:13 PM, George Silva <georger.silva@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
