public inbox for [email protected]  

help / color / mirror / Atom feed

From: Peter Eisentraut <[email protected]>
To: Bruce Momjian <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: Alvaro Herrera <[email protected]>
Cc: Susanne Ebrecht <[email protected]>
Cc: Robert Haas <[email protected]>
Cc: Grzegorz Szpetkowski <[email protected]>
Cc: pgsql-docs <[email protected]>
Subject: Re: createuser/dropuser username
Date: Mon, 12 Sep 2011 22:18:59 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

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?

view thread (18+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: createuser/dropuser username
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox