Re: can not create user name in Capital letter

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: can not create user name in Capital letter
Date: 2009-11-03 08:03:49
Message-ID: hcoo54$305$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Shruthi A 2009-11-03 08:53:51 Re: Need help in enabling remote connection
Previous Message Hengky Lie 2009-11-03 07:41:59 Re: Please Help... Service fails to start