From: | Susanne Ebrecht <susanne(at)2ndQuadrant(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Grzegorz Szpetkowski <gszpetkowski(at)gmail(dot)com>, pgsql-docs(at)postgresql(dot)org |
Subject: | Re: createuser/dropuser username |
Date: | 2011-05-20 09:09:53 |
Message-ID: | 4DD62FE1.9010607@2ndQuadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On 19.05.2011 22:15, Robert Haas wrote:
> On Wed, May 4, 2011 at 12:05 PM, Grzegorz Szpetkowski
> <gszpetkowski(at)gmail(dot)com> wrote:
>> Hi,
>>
>> I think that createuser/drouser reference documentation could be
>> enhanced for username param. There is:
>>
>> "createuser is a wrapper around the SQL command CREATE ROLE. There is
>> no effective difference between creating users via this utility and
>> via other methods for accessing the server."
>>
>> http://www.postgresql.org/docs/9.0/static/app-createuser.html
>> http://www.postgresql.org/docs/9.0/static/app-dropuser.html
>>
>> But createuser and dropuser wrappers in some cases are doing implicit
>> quoting (when CREATE ROLE is not), which I think is not fully known
>> and is undocumented here. For example:
> I'm not sure this really needs to be documented, but what exactly do
> you have in mind?
Honestly, I think we should document that the scripts use quotes.
I just made an ad-hoc look into the docs and couldn't find something
about it.
Lots of years ago - you could see me sitting in front of my computer and
wondering - because I used:
$ createdb test
$ createdb tEst
I wondered that I didn't got an error message.
Thinking deeper about it just let it get logical to me that createdb
quotes by
automatism.
But this isn't logical on the first view - because we point out that all
will get
to lower case without quotes.
PostgreSQL even is so intelligent - that when you say:
$ createdb "tEst" - it will ignore the quotes - you will get database
named tEst and not
named "tEst".
This all isn't really obvious to a typical user.
Best Regards,
Susanne
--
Susanne Ebrecht - 2ndQuadrant
PostgreSQL Development, 24x7 Support, Training and Services
www.2ndQuadrant.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-05-20 11:56:58 | Re: non-ASCII characters in SGML documentation (and elsewhere) |
Previous Message | Susanne Ebrecht | 2011-05-20 08:44:49 | Re: non-ASCII characters in SGML documentation (and elsewhere) |