DatabaseMetaData.getTables() is silently quoting table identifiers?

Поиск
Список
Период
Сортировка
От Marc Herbert
Тема DatabaseMetaData.getTables() is silently quoting table identifiers?
Дата
Msg-id khjd5c0jlhp.fsf@meije.emic.fr
обсуждение исходный текст
Ответы Re: DatabaseMetaData.getTables() is silently quoting table
Список pgsql-jdbc
Hi,

 If I create table MY_TABLE (unquoted uppercase), then my_table
(lowercase) is actually created. This is clearly documented, so fine.

<http://www.postgresql.org/docs/8.1/interactive/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS>

But now if I use .getTables(null, null, "MY_TABLE", null) to ask
whether this table actually exists, the answer is "no" (empty) because
.getTables() acts like I quoted the MY_TABLE identifier.

It's quite annoying to create a table and not be able to see it...

Tested with  postgresql-server.i686 8.0.7-1PGDG and 8.2dev-503
Maybe this is a server-side issue?


Cheers,

Marc


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Marc Herbert
Дата:
Сообщение: "prepared" statements (Re: Limit vs setMaxRows issue)
Следующее
От: Mark Lewis
Дата:
Сообщение: Re: DatabaseMetaData.getTables() is silently quoting table