Retrieve the primary key of a table - Mailing list pgsql-novice

From Alejandro
Subject Retrieve the primary key of a table
Date
Msg-id 86eeef650908021924q3012d8e6saabfcda70349850b@mail.gmail.com
Whole thread Raw
Responses Re: Retrieve the primary key of a table  (Michael Wood <esiotrot@gmail.com>)
Re: Retrieve the primary key of a table  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Retrieve the primary key of a table  (Lacey Powers <lacey.powers@commandprompt.com>)
List pgsql-novice
Hi. I need to retrieve the primary key of a table and their value.

I tried with this http://wiki.postgresql.org/wiki/Retrieve_primary_key_columns:

SELECT               
pg_attribute.attname,
format_type(pg_attribute.atttypid, pg_attribute.atttypmod)
FROM pg_index, pg_class, pg_attribute
WHERE
pg_class.oid = 'TABLENAME'::regclass AND
indrelid = pg_class.oid AND
pg_attribute.attrelid = pg_class.oid AND
pg_attribute.attnum = any(pg_index.indkey);
But this shows indexes too. http://wiki.postgresql.org/wiki/Talk:Retrieve_primary_key_columns

How can I get only the primary key?

I have postgres 8.1.11.

Thanks, Alejandro.

pgsql-novice by date:

Previous
From: Lacey Powers
Date:
Subject: Re: Synchronizing the schema of two PostgreSQL databases
Next
From: Jasen Betts
Date:
Subject: Re: Weekends between