From: | Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk> |
---|---|
To: | "'Alex Verstak'" <averstak(at)vt(dot)edu>, pgsql-interfaces(at)postgresql(dot)org |
Subject: | RE: [INTERFACES] JDBC primary keys |
Date: | 2000-02-10 08:46:23 |
Message-ID: | 1B3D5E532D18D311861A00600865478C70C1A5@exchange1.nt.maidstone.gov.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
of them.
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-----Original Message-----
From: Alex Verstak [mailto:averstak(at)vt(dot)edu]
Sent: Wednesday, February 09, 2000 11:51 PM
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: [INTERFACES] 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
************
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2000-02-10 08:46:37 | RE: [INTERFACES] pgAdmin on NT (NT4SP6) |
Previous Message | Peter Mount | 2000-02-10 08:42:51 | RE: [INTERFACES] NOTIFY/LISTEN with JDBC |