Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id E4E80B5DBC4
	for <pgsql-docs-postgresql.org@mail.postgresql.org>;
	Mon, 12 Sep 2011 16:19:16 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 77395-08 for
	<pgsql-docs-postgresql.org@mail.postgresql.org>;
	Mon, 12 Sep 2011 19:19:10 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mailout-de.gmx.net (mailout-de.gmx.net [213.165.64.23])
	by mail.postgresql.org (Postfix) with SMTP id 28CFAB5D91F
	for <pgsql-docs@postgresql.org>; Mon, 12 Sep 2011 16:19:09 -0300 (ADT)
Received: (qmail invoked by alias); 12 Sep 2011 19:19:08 -0000
Received: from a88-115-218-165.elisa-laajakaista.fi (EHLO [10.0.0.102])
	[88.115.218.165]
	by mail.gmx.net (mp049) with SMTP; 12 Sep 2011 21:19:08 +0200
X-Authenticated: #495269
X-Provags-ID: V01U2FsdGVkX196Ps9M++16qun6IzsWgLpPuNVRva5R4W4FtSUfAL
	sd0ABdx52xGjrh
Subject: Re: createuser/dropuser username
From: Peter Eisentraut <peter_e@gmx.net>
To: Bruce Momjian <bruce@momjian.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Alvaro Herrera
	<alvherre@commandprompt.com>, Susanne Ebrecht <susanne@2ndquadrant.com>,
	Robert Haas <robertmhaas@gmail.com>, Grzegorz Szpetkowski
	<gszpetkowski@gmail.com>, pgsql-docs <pgsql-docs@postgresql.org>
Date: Mon, 12 Sep 2011 22:18:59 +0300
In-Reply-To: <201109092348.p89NmMu12417@momjian.us>
References: <201109092348.p89NmMu12417@momjian.us>
Content-Type: text/plain; charset="UTF-8"
X-Mailer: Evolution 3.0.2- 
Content-Transfer-Encoding: 7bit
Message-ID: <1315855149.19706.19.camel@vanquo.pezone.net>
Mime-Version: 1.0
X-Y-GMX-Trusted: 0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.403 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001,
	RP_MATCHES_RCVD=-0.504
X-Spam-Level: 
X-Archive-Number: 201109/43
X-Sequence-Number: 6964

On fre, 2011-09-09 at 19:48 -0400, Bruce Momjian wrote:
> !         Specifies the default tablespace for the database. (This name
> !         is processed as a double-quoted identifier.)

I don't find this wording particularly useful.  What does it mean?  The
imaginary double quotes are stripped off?

The advantage of using the shell tools is that you are not affected by
the oddities of SQL syntax, so don't introduce references to SQL syntax
where it doesn't need to be.  Just say, the names are used as is.  Or
just say nothing, because nothing happens.

> !         Specifies the name of the procedural language to be
> !         installed.  (This name is lower-cased.)

Maybe an explanation why would be in order here.

> +    <para>
> +     When specified on the command line, user and databases names have
> +     their case preserved &mdash; the presence of spaces or special
> +     characters might require quoting.  Table names and other identifiers
> +     do not have their case preserved, except where documented, and
> +     might require quoting.
> +    </para>

What kind of quoting might be required?