Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: determine if a column is UNIQUE using metadata
- From: Kris Jurka <books(at)ejurka(dot)com>
- To: Peter Michaux <petermichaux(at)gmail(dot)com>
- Cc: pgsql-jdbc(at)postgresql(dot)org
- Subject: Re: determine if a column is UNIQUE using metadata
- Date: Sun, 20 Jan 2008 10:15:19 -0500 (EST)
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
- References:
- determine if a column is UNIQUE using metadata
- From: Peter Michaux
- determine if a column is UNIQUE using metadata
- Prev by Date: determine if a column is UNIQUE using metadata
- Next by Date: Re: trying to connect to pg from within a local network
- Previous by thread: determine if a column is UNIQUE using metadata
- Next by thread: Update zh_TW translation po file. (73%)
- Indexes: