Uppercase user name created using createuser command stores name within double quotes
I am currently using postgreql-9.0. When i create user (as su postgres) using createuser command with name all in UPPERCASE, the name gets stored within double quotes. But creating user inside psql prompt converts UPPERCASE to lower case... Whats really happening? Please advice..
Unless enclosed in double quotes, Postgres converts everything to lowercase.
When using the createuser command, it must be assuming you really want it in uppercase and automatically provides the double quotes for you to keep it that way.
When doing it from within psql, it is not automatically adding the double quotes for you, so it is being converted to lowercase. To keep it all caps, you need to add double quotes.
To avoid all this weirdness, just create lowercase users.