Wednesday, March 6, 2002 07:42 AM
Does anyone know a way of getting a list of all candidate keys for a table? (all "UNIQUE" sets of columns defined when creating a table).
I looked in DatabaseMetaData, but there you can only get a list of primary key fields.
I'm using Java 1.3.1 with a PostgreSQL backend.