Quoted object names #1878
Replies: 4 comments 1 reply
-
The name quoting mechanism in pgModeler follows almost all the rules defined by PostgreSQL, see here: |
Beta Was this translation helpful? Give feedback.
-
Hi @rkhaotix Thanks for getting at this. I am afraid, I do not agree with you. The section mentioned by you states: But pgModeler's I see topics there:
I have to admit, I did not test the very latest pgModeler version as I do not have access to it. My latest is 1.0.1. It might be different in later ones. Long live Asterix! Thiemo |
Beta Was this translation helpful? Give feedback.
-
It's ok to disagree. That's why I said "almost all the rules". :) pgModeler historically (and by request from users in the past) automatically double-quotes any object name that isn't purely lower case. This is also a consent among PostgreSQL community. If you will use upper case latters, make sure to always type the object names between doubleq uotes to avoid confusion. That's why they recommend to always use lower case names :) Unfortunately, I can't say that to make the automatic double-quotes optional via setting is easy, because it isn't, there are too many things that depends on it. :( |
Beta Was this translation helpful? Give feedback.
-
I see, a deliberate break with the working of PostgreSQL then. I know of the recommendation of PostgreSQL to use lower case identifiers and upper case keywords. To me, it makes rather more sense to write the identifiers upper, and the keywords lower case, sort of counter-weight to the syntax highlighted colouring of the keywords. But that is just a personal preference. |
Beta Was this translation helpful? Give feedback.
-
Hi
I noticed that some object names are generated in quoted form even though quotes were not given in the definition of the object. Is there a specific reason for that? I believe objects not purely in lower case get quoted. As I am not aware of the SQL standard requiring so, and much more, as far as I know, PostgreSQL converts all unquoted names to lower case. I quite feel that there is an unnecessary restriction in place.
I would appreciate some enlightment.
Cheers
Thiemo
Beta Was this translation helpful? Give feedback.
All reactions