Re: Valid characters for user/role/group names?

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/