Case folding in DatabaseMetaData - Mailing list pgsql-jdbc

From Benoit Menendez
Subject Case folding in DatabaseMetaData
Date
Msg-id 000a01c1bfcb$545de330$0201a8c0@osprey
Whole thread Raw
List pgsql-jdbc
Since PostgreSQL folds all table and column names (to lowercase), shouldn't the DatabaseMetaData calls do the same:
 
for example:
 
create table FOO ...
 
DatabaseMetaData.getColumns(null, null, "FOO", "%") returns nothing since FOO has been folded to lowercase
 
The same goes with other DatabaseMetaData taking table or column names (or patterns)...
 
A fix would be to use the case insensitive like operator when querying system tables...
 
This applies to both ODBC and JDBC as far as I can tell...
 
I am using the latest stable versions of 7.2 and corresponding ODBC and JDBC drivers...
 
Thanks for your comments on the subject...
 
    Benoit

pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: Blob support...
Next
From: Barry Lind
Date:
Subject: Re: Blob support...