[ADMIN] can not create user name in Capital letter

2009-11-02 Thread donghe
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@postgresql.org) To make ch

Re: [ADMIN] can not create user name in Capital letter

2009-11-02 Thread Lewis Kapell
You need to put double-quotes (") around your username, db name etc. - otherwise everything is reduced to lower case. Lewis don...@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 c

Re: [ADMIN] can not create user name in Capital letter

2009-11-02 Thread Emanuel Calvo Franco
2009/11/2 : > 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";

Re: [ADMIN] can not create user name in Capital letter

2009-11-03 Thread Thomas Kellerer
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";