Re: Case sensitive without quotes

From: Richard Huxton <dev(at)archonet(dot)com>
To: Jason Long <mailing(dot)list(at)supernovasoftware(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Case sensitive without quotes
Date: 2009-02-06 17:10:42
Message-ID: 498C6F12.2090105@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fernando Moreno 2009-02-06 18:06:36 Re: How do I turn on query logger?
Previous Message Jason Long 2009-02-06 16:49:03 Case sensitive without quotes