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


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

Lewis


donghe [at] 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
>
>


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

2009/11/2 <donghe [at] 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

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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 name that is). I'm pretty sure that will cause more trouble than it's worth.

Thomas


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin