How to find primary keys?

I would like a list of all the primary key columns in all my tables. I'm
thinking of something simple like

select table_name, column_name from cols where <what is the condition?>;

TIA

-- 
Tim Spellman                    | IntraNet, Inc. provides
mission-critical
TSpellman_at_IntraNet.com          | electronic payment systems and related
617-527-3399 x564               | solutions worldwide.