Re: Valid characters for user/role/group names? - Mailing list pgsql-general

From Sam Mason
Subject Re: Valid characters for user/role/group names?
Date
Msg-id 20090225165848.GV32672@frubble.xen.chris-lamb.co.uk
Whole thread Raw
In response to Valid characters for user/role/group names?  ("Roderick A. Anderson" <raanders@cyber-office.net>)
Responses Re: Valid characters for user/role/group names?
List pgsql-general
On Wed, Feb 25, 2009 at 08:50:15AM -0800, Roderick A. Anderson wrote:
> http://www.postgresql.org/docs/current/interactive/sql-syntax-lexical.html
>
> "SQL identifiers and key words must begin with a letter (a-z, but also
> letters with diacritical marks and non-Latin letters) or an underscore
> (_). Subsequent characters in an identifier or key word can be letters,
> underscores, digits (0-9), or dollar signs ($). Note that dollar signs
> are not allowed in identifiers according to the letter of the SQL
> standard, so their use might render applications less portable. ... "

You'd want to put double quotes around the identifier.  Try searching
for "quoted identifier" in the above page.

--
  Sam  http://samason.me.uk/

pgsql-general by date:

Previous
From: "Roderick A. Anderson"
Date:
Subject: Valid characters for user/role/group names?
Next
From: Tom Lane
Date:
Subject: Re: Valid characters for user/role/group names?