Thread: Case sensitive without quotes

Case sensitive without quotes

From
Jason Long
Date:
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

From
Richard Huxton
Date:
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