Обсуждение: Case sensitive without quotes

Поиск
Список
Период
Сортировка

Case sensitive without quotes

От
Jason Long
Дата:
Is there any way to have Postgres preserve the case of tables and column
names in queries without having to use quotes for columns with mixed case?

Re: Case sensitive without quotes

От
Richard Huxton
Дата:
Jason Long wrote:
> Is there any way to have Postgres preserve the case of tables and column
> names in queries without having to use quotes for columns with mixed case?

No.

PostgreSQL folds to lower-case (the SQL standard specifies upper-case
iirc) to provide case-insensitivity.

--
  Richard Huxton
  Archonet Ltd