CODEWITHSUNDEEP
postgresql
SILENT
SILENT

Reputation: 4258

Postgres - disable lowering case of query

Is there any flag or option that can be set to disable Postgres from lowering query casing? (ie SELECT firstName, lastName, ... is converted by Postgres to SELECT firstname, lastname, ... )

Yes, I already know if you use double quotes, it will preserve case. And I know because of this annoying behavior, most recommend not to use case sensitive columns, forcing users to only use something other than Pascal naming schemes like snake naming schemes. I don't get why this behavior was built-in the first place.

Upvotes: 1

Views: 1043

Answers (1)

mustaccio
mustaccio

Reputation: 18945

SQL identifiers must be case-insensitive, unless quoted, according to the standard. So, no, you cannot change this behaviour (unless you're willing to modify Postgres source code and render it even less standard-compliant than it already is).

See also this Q&A

Upvotes: 2

Related Questions