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
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 |