Re: [PATCH] problem with DatabaseMetaData and mixed case - Mailing list pgsql-jdbc

From Giuseppe Sacco
Subject Re: [PATCH] problem with DatabaseMetaData and mixed case
Date
Msg-id 1123545227.9087.1.camel@localhost
Whole thread Raw
In response to Re: [PATCH] problem with DatabaseMetaData and mixed case  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Il giorno lun, 08/08/2005 alle 16.55 -0500, Kris Jurka ha scritto:
[...]
> Postgresql folds identifiers to lowercase as long as they are created
> without quotes.  Using CREATE TABLE "MyTable" (...) will indeed retain the
> case of MyTable.  We do not fold DatabaseMetaData parameters to lowercase
> because that would prevent you from retrieving data from a table created
> as "MyTable".  The DatabaseMetaData methods like
> storesLowerCaseIdentifiers() helps allow portable code to call the other
> methods with the correct name.  It doesn't help you if you don't know if
> the table name was originally created as MyTable or "MyTable", but if
> that's the case a call to getTables may be in order.
>
> Kris Jurka

Thank you, and to Oliver Jowett, for this explaination.

Giuseppe


pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: [PATCH] problem with DatabaseMetaData and mixed case table
Next
From: "Barry Lind"
Date:
Subject: Is anyone aware that the 8.1dev download links on the website are broken?