Skip site navigation (1) Skip section navigation (2)

RE: [INTERFACES] JDBC primary keys

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: (view raw, whole thread or download thread mbox)
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 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:
    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


pgsql-interfaces by date

Next:From: Dave PageDate: 2000-02-10 08:46:37
Subject: RE: [INTERFACES] pgAdmin on NT (NT4SP6)
Previous:From: Peter MountDate: 2000-02-10 08:42:51

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group