How to get the name of a table's primary key?

Hi,

I'm sorry if this is a stupid question, but how can I obtain the name
of a primary key of a given table? Suppose I've got a simple table
like this:

create table foo (
foo_pkey int primary key,
foo_data varchar(50)
);

In a programme I only know the table name "foo" and want to get the
name of the primary key.
Any help on this?

Cheers,
Chris

--
Christian von Kietzell
mailto: chris(at)gammu(dot)ath(dot)cx
Jabber: cuboci(at)charente(dot)de