Re: Camel case identifiers and folding

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Steve Haresnape <s(dot)haresnape(at)creativeintegrity(dot)co(dot)nz>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Camel case identifiers and folding
Date: 2019-03-14 23:21:02
Message-ID: CAKFQuwaBpYUPng4O=Q3ge3KUytsrt+VYb4u8J-C8dd9dum9Ehw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Mar 14, 2019 at 4:07 PM Steve Haresnape
<s(dot)haresnape(at)creativeintegrity(dot)co(dot)nz> wrote:
>
> I'm porting a sql server database to postgresql 9.6. My camelCase identifiers are having their humps removed. This is disconcerting and sad.
>
> Is there a cure for this?

No

>I don't want to quote my identifiers unless I have to.

PostgreSQL made the choice long ago to normalize unquoted identifiers
to lower case. Quoting them will preserve whatever you type,
including case.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message fuzk 2019-03-15 02:12:05 Re:Re: ERROR: XX000: cannot update SecondarySnapshot during a parallel operation
Previous Message Steve Haresnape 2019-03-14 23:06:55 Camel case identifiers and folding