CODEWITHSUNDEEP
postgresqlpg-dump
Gargoyle
Gargoyle

Reputation: 10345

postgres case sensitive for function names

When I create my function in postgres and call it something like getOrder it works just fine. However, when I then do a pg_dump, it dumps it as getorder, thus not preserving the case. That makes everything break if I have to do a restore.

I found I could get it to keep the case if I quote it, like: CREATE FUNCTION "getOrder"()...

but then whenever I call it, I have to actually call it with the quotes, which makes that a pain for things like PHP.

Is there a way to simply tell postgres to leave the case of the method names alone? I know I can solve by calling it something like get_order, but I'd prefer to keep the casing the way I created the function.

Upvotes: 0

Views: 295

Answers (1)

Erwin Brandstetter
Erwin Brandstetter

Reputation: 657982

No, there is no option to do that. It would break expected behavior badly.

My standing advice is to use legal, lower-case names exclusively and never have to worry about this issue. Be sure to read the chapter about Identifiers and Key Words in the manual.

Upvotes: 1

Related Questions