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: 1B3D5E532D18D311861A00600865478C70C1A5@exchange1.nt.maidstone.gov.uk (view raw or flat)
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



************

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
Subject: RE: [INTERFACES] NOTIFY/LISTEN with JDBC

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