Re: determine if a column is UNIQUE using metadata - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: determine if a column is UNIQUE using metadata
Date
Msg-id Pine.BSO.4.64.0801201012410.22317@leary.csoft.net
Whole thread Raw
In response to determine if a column is UNIQUE using metadata  ("Peter Michaux" <petermichaux@gmail.com>)
List pgsql-jdbc

On Sat, 19 Jan 2008, Peter Michaux wrote:

> I've been trying to determine if a column is UNIQUE. I've been trying
> to use the following
>
> connection.getMetaData().getIndexInfo(null, "", "comment", false, true);
>
> but it always says that the columns are not unique.
>
> Am I on the right track with the above technique or should I be trying
> to do something totally different?
>

The driver's test suite includes a test for ensuring NON_UNIQUE is
returned correctly and it works for me.  Could you post a complete example
(including table/index creation) of it failing.

Kris Jurka

pgsql-jdbc by date:

Previous
From: "Peter Michaux"
Date:
Subject: determine if a column is UNIQUE using metadata
Next
From: "Albe Laurenz"
Date:
Subject: Re: trying to connect to pg from within a local network