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

From Tom Lane
Subject Re: Valid characters for user/role/group names?
Date
Msg-id 27414.1235581515@sss.pgh.pa.us
Whole thread Raw
In response to Re: Valid characters for user/role/group names?  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
Sam Mason <sam@samason.me.uk> writes:
> You'd want to put double quotes around the identifier.  Try searching
> for "quoted identifier" in the above page.

Note that the double quotes would be needed when referencing the role
identifier in SQL commands (eg CREATE ROLE).  In other contexts, such
as pg_hba.conf or psql's command-line -U switch, the rules might well
be different; you might not need quotes, or you might need some other
kind of quoting.  I'd suggest a bit of experimenting before you
settle on a grand plan.

            regards, tom lane

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Valid characters for user/role/group names?
Next
From: Magnus Hagander
Date:
Subject: Re: Several simultaneous libpq connections from the same application to different servers using different SSL certs