On Tue, 2010-08-03 at 16:13 -0300, George Silva wrote: > 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? See pg_index.indisprimary column. If it is true, then the it is the PK of given table. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment:
signature.asc
Description: This is a digitally signed message part
