From: Alex Verstak <averstak@vt.edu>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] JDBC primary keys
Date: Thu, 10 Feb 2000 10:56:19 -0500
Message-ID: <200002101556.KAA94266@averstak.campus.vt.edu> (raw)
In-Reply-To: <1B3D5E532D18D311861A00600865478C70C1A5@exchange1.nt.maidstone.gov.uk>
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@vt.edu]
> Sent: Wednesday, February 09, 2000 11:51 PM
> To: pgsql-interfaces@postgreSQL.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@vt.edu
> 1078 Ambler Johnston East Virginia Tech
> Blacksburg, VA 24060-0022 Tel. (540) 232-1389
>
>
>
> ************
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: averstak@vt.edu
Subject: Re: [INTERFACES] JDBC primary keys
In-Reply-To: <200002101556.KAA94266@averstak.campus.vt.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox