What version of the driver are you using? Earlier versions had some
problems and this one (returning `foo_pk' for all rows) looks like one
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
From: Alex Verstak [mailto:averstak(at)vt(dot)edu]
Sent: Wednesday, February 09, 2000 11:51 PM
Subject: [INTERFACES] JDBC primary keys
Is there a way to determine all primary key columns in
a given table? Example:
CREATE TABLE foo (
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?
Alex Verstak averstak(at)vt(dot)edu
1078 Ambler Johnston East Virginia Tech
Blacksburg, VA 24060-0022 Tel. (540) 232-1389
pgsql-interfaces by date
|Next:||From: Dave Page||Date: 2000-02-10 08:46:37|
|Subject: RE: [INTERFACES] pgAdmin on NT (NT4SP6)|
|Previous:||From: Peter Mount||Date: 2000-02-10 08:42:51|
|Subject: RE: [INTERFACES] NOTIFY/LISTEN with JDBC|