DatabaseMetaData.getIndexInfo and function-based indexes - Mailing list pgsql-jdbc

From peter royal
Subject DatabaseMetaData.getIndexInfo and function-based indexes
Date
Msg-id 2BDB6E76-8200-11D9-8AAF-000A95AC787E@pace2020.com
Whole thread Raw
Responses Re: DatabaseMetaData.getIndexInfo and function-based indexes  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
say i have an index:

create index my_index on my_Table (upper(my_field) );

it is possible to retrieve the fact that the field is upper(my_field)
via DMD.getIndexInfo() ?

With 7.4 (and the associated JDBC driver) the column name shows up as
pg_expression_1 (or something very close to that :)

... or is this something that is fixed in 8.0?

Thanks.

-pete

Attachment

pgsql-jdbc by date:

Previous
From: John R Pierce
Date:
Subject: Re: jdbc and windows
Next
From: Kris Jurka
Date:
Subject: Re: DatabaseMetaData.getIndexInfo and function-based indexes