DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=AQVKHCuJ/iV4ZglR9Ld1j4LW5Qfe5DyiExqMI9qyWpV0AJyOauJu3oCHDKub9/WW+B
	nLVtd7wdoGJawjUhG9JVXwx3eNuroGg9FN+HMuUL9O9ShWh+wFpqoJ6XI+7RMl98rSaF
	SxzbKqN4wTHvILXSY3Jwg+JFUgXY5mo1c7diY=
MIME-Version: 1.0
In-Reply-To: <BANLkTik=8Mi4L9n=8=P0ez4Xen4YuGX8vw@mail.gmail.com>
References: <BANLkTik=8Mi4L9n=8=P0ez4Xen4YuGX8vw@mail.gmail.com>
Date: Thu, 19 May 2011 16:15:23 -0400
Message-ID: <BANLkTinBHVbx+Wqp9vAGLkW7LyEm5iK_0w@mail.gmail.com>
Subject: Re: createuser/dropuser username
From: Robert Haas <robertmhaas@gmail.com>
To: Grzegorz Szpetkowski <gszpetkowski@gmail.com>
Cc: pgsql-docs@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1

On Wed, May 4, 2011 at 12:05 PM, Grzegorz Szpetkowski
<gszpetkowski@gmail.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?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company