Re: can not create user name in Capital letter - Mailing list pgsql-admin

From Thomas Kellerer
Subject Re: can not create user name in Capital letter
Date
Msg-id hcoo54$305$1@ger.gmane.org
Whole thread Raw
In response to Re: can not create user name in Capital letter  (Emanuel Calvo Franco <postgres.arg@gmail.com>)
List 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
namethat is). I'm pretty sure that will cause more trouble than it's worth. 

Thomas

pgsql-admin by date:

Previous
From: Hengky Lie
Date:
Subject: Re: Please Help... Service fails to start
Next
From: Shruthi A
Date:
Subject: Re: Need help in enabling remote connection