Re: metadata searching

Поиск
Список
Период
Сортировка
От Juriy Goloveshkin
Тема Re: metadata searching
Дата
Msg-id 001801c3eafa$8c2d79e0$f2c745d9@hjugonb
обсуждение исходный текст
Ответ на metadata searching  ("Juriy Goloveshkin" <j@gu.ru>)
Список pgsql-jdbc
> You may not know this, but you can create objects with case sensitive
names:
>
> create table "Base" (columna integer);
> create table "BASE" (columna integer);
> create table Base (columna integer);
I know this. it's good if it's an sql-standard. What does it change?
>
> The first two creates will create tables whose names are case-sensitive
> and thus in order to access these tables you will always need to quote
> their names so that the SQL parser knows to retain the case.  The last
> create above will create a lowercase named table as postgres folds
> unquoted identifiers to lowercase.
>
> Now the interesting thing when it comes to jdbc is that all three of the
> above tables can exist at the same time.
sql-engine can work with whis. Why jdbc code doesn't?
Did you play with your example in psql with \d <name> command? Something
different with getTable in jdbc? :) Why?



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

Предыдущее
От: "Juriy Goloveshkin"
Дата:
Сообщение: Re: metadata searching
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: Postgresql 7.4.1 and JDBC setFetchSize