Re: [PATCH] problem with DatabaseMetaData and mixed case

From: Giuseppe Sacco <giuseppe(at)eppesuigoccas(dot)homedns(dot)org>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [PATCH] problem with DatabaseMetaData and mixed case
Date: 2005-08-08 23:53:46
Message-ID: 1123545227.9087.1.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2005-08-09 17:19:20 Is anyone aware that the 8.1dev download links on the website are broken?
Previous Message Oliver Jowett 2005-08-08 22:07:17 Re: [PATCH] problem with DatabaseMetaData and mixed case table