#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2012
    Posts
    1
    Rep Power
    0

    Cool Uppercase user name created using createuser command stores name within double quotes


    Hi,

    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..

    Thanks,
    Saravanan
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2012
    Posts
    14
    Rep Power
    0
    Hi,

    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.

    Joe

IMN logo majestic logo threadwatch logo seochat tools logo