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