JDBC primary keys

Is there a way to determine all primary key columns in
a given table? Example:

CREATE TABLE foo (
bar1 int4,
bar2 text,
bar3 float8,
CONSTRAINT foo_pk PRIMARY KEY ( bar1, bar2 )
)

I want to obtain `bar1' and `bar2' given table name `foo'.

DatabaseMetaData.getPrimaryKeys looks like the right
function to use, but it returns `foo_pk' in COLUMN_NAME
for all rows.

Am I misinterpreting the JDBC specs? What SELECT query
should I use to get the primary key columns?

--
Drive^H^Hnk safely!
Alex Verstak averstak(at)vt(dot)edu
1078 Ambler Johnston East Virginia Tech
Blacksburg, VA 24060-0022 Tel. (540) 232-1389