As I said, I don't want to quote my identifiers. I know what that does. I want to specify them in a certain way, see them in that same way, but refer to them in any old way.
You can call it normalize or fold or whatever. It's a bad design choice, and not even a completely compliant choice.
Is a cure contemplated? I know it's not just me that dislikes this.
On Thu, Mar 14, 2019 at 4:07 PM Steve Haresnape <s.haresnape@creativeintegrity.co.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.