Postgres Pro
Downloads
Home   >   mailing lists

Re: Case sensitive without quotes - Mailing list pgsql-general

From Richard Huxton
Subject Re: Case sensitive without quotes
Date
Msg-id 498C6F12.2090105@archonet.com
Whole thread Raw
In response to Case sensitive without quotes  (Jason Long <mailing.list@supernovasoftware.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jason Long
Date:
Subject: Case sensitive without quotes
Next
From: Fernando Moreno
Date:
Subject: Re: How do I turn on query logger?