Re: [PATCH] problem with DatabaseMetaData and mixed case

Поиск
Список
Период
Сортировка
От Giuseppe Sacco
Тема Re: [PATCH] problem with DatabaseMetaData and mixed case
Дата
Msg-id 1123545227.9087.1.camel@localhost
обсуждение исходный текст
Ответ на Re: [PATCH] problem with DatabaseMetaData and mixed case  (Kris Jurka <books@ejurka.com>)
Список 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 по дате отправления:

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: [PATCH] problem with DatabaseMetaData and mixed case table
Следующее
От: "Barry Lind"
Дата:
Сообщение: Is anyone aware that the 8.1dev download links on the website are broken?