Thread: can not create user name in Capital letter

Hi,

I have a trouble in creating user and database in postgres. whenever I
create user or databases in capital letters, the names are always
converted into names in lower case letter. what's wrong with it?
Thanks

Dong

You need to put double-quotes (") around your username, db name etc. -
otherwise everything is reduced to lower case.

Lewis


donghe@caltech.edu wrote:
> Hi,
>
> I have a trouble in creating user and database in postgres. whenever I
> create user or databases in capital letters, the names are always
> converted into names in lower case letter. what's wrong with it?
> Thanks
>
> Dong
>
>

2009/11/2  <donghe@caltech.edu>:
> Hi,
>
> I have a trouble in creating user and database in postgres. whenever I
> create user or databases in capital letters, the names are always
> converted into names in lower case letter. what's wrong with it?
> Thanks
>
> Dong

Try add ""


CREATE USER "PepeArgento";

              Emanuel Calvo Franco
             DBA at:  www.siu.edu.ar
        www.emanuelcalvofranco.com.ar

Emanuel Calvo Franco, 02.11.2009 21:27:
>> I have a trouble in creating user and database in postgres. whenever I
>> create user or databases in capital letters, the names are always
>> converted into names in lower case letter. what's wrong with it?
>> Thanks
>>
>> Dong
>
> Try add ""
>
>
> CREATE USER "PepeArgento";
>

While one can certainly do that, I would strongly discourage the usage of mixed case user names (or any other object
namethat is). I'm pretty sure that will cause more trouble than it's worth. 

Thomas