The following bug has been logged online: Bug reference: 3480 Logged by: Andrei Badea Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Debian GNU/Linux testing/lenny, Linux 2.6.17 Description: JDBC driver: getIndexInfo() returns quotes around quoted column names Details:
JDBC3 driver 8.2-505 and JDBC4 driver 8.3dev-600. The DatabaseMetaData.getIndexInfo() method returns quotes around quoted column names, unlike the getColumns() method. To reproduce run the following statement in a database named "test" and the "public" schema: create table "CUSTOMER" ("CUSTOMER_ID" int not null primary key); connect to the database and execute the following code: // java.sql.Connection conn DatabaseMetaData dmd = conn.getMetaData(); // print the columns ResultSet rs = dmd.getColumns("test", "public", "CUSTOMER", "%"); try { while (rs.next()) { System.out.println(rs.getString("COLUMN_NAME")); } } finally { rs.close(); } // print the primary key columns rs = dmd.getIndexInfo("test", "public", "CUSTOMER", true, true); try { while (rs.next()) { System.out.println(rs.getString("COLUMN_NAME")); } } finally { rs.close(); } The code prints CUSTOMER_ID "CUSTOMER_ID" while it should probably have printed CUSTOMER_ID CUSTOMER_ID ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster