Re: Camel case identifiers and folding

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Camel case identifiers and folding
Date: 2019-03-15 06:50:23
Message-ID: eb20eec0-8964-90ae-8294-f987a1c6b8c9@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Steve Haresnape schrieb am 15.03.2019 um 00:06:
> 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?
>
> I don't want to quote my identifiers unless I have to.

You don't need to.
Nothing prevents you from writing CustomerOrders if the table was not created with double quotes.

The only thing is, that the name is stored differently.
But you can still use CamelCase all over the place if stick to unquoted identifiers.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wim Bertels 2019-03-15 09:12:40 Re: Camel case identifiers and folding
Previous Message David G. Johnston 2019-03-15 06:33:52 Re: Facing issue in using special characters