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

Re: [INTERFACES] JDBC primary keys

From: "Alex Verstak" <averstak(at)vt(dot)edu>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] JDBC primary keys
Date: 2000-02-10 15:56:19
Message-ID: 200002101556.KAA94266@averstak.campus.vt.edu (view raw or flat)
Thread:
Lists: pgsql-interfaces
  postgresql.Driver:
    MAJORVERSION = 6
    MINORVERSION = 5
  
  This is the one included with PostgreSQL 6.5.3.  What/where is the
  latest stable version of the JDBC driver?
  
  Thank you,
Alex Verstak
Virginia Tech

  
Peter Mount wrote:
> 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: Peter MountDate: 2000-02-10 16:24:52
Subject: RE: [INTERFACES] JDBC primary keys
Previous:From: Paul RijkeDate: 2000-02-10 15:08:06
Subject: Programming tips Access 2000 / ODBC postgres?

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