Postgres Pro
Downloads
Home   >   mailing lists

Re: Username with a hyphen character (grant failing?) - Mailing list pgsql-general

From Tom Lane
Subject Re: Username with a hyphen character (grant failing?)
Date
Msg-id 5057.990800854@sss.pgh.pa.us
Whole thread Raw
In response to Username with a hyphen character (grant failing?)  (Sean Chittenden <sean-pgsql-general@chittenden.org>)
Responses Re: Username with a hyphen character (grant failing?)  (Sean Chittenden <sean-pgsql-general@chittenden.org>)
List pgsql-general
Tree view 
Sean Chittenden <sean-pgsql-general@chittenden.org> writes:
>     What's the scoop with username constraints?  I setup and
> created a user with a '-' character in the middle (worked).

Double quotes are your friend when dealing with names that don't
follow the usual constraints for identifiers.

            regards, tom lane

pgsql-general by date:

Previous
From: "Len Morgan"
Date:
Subject: Re: COPY with default values?
Next
From: Manuel Durán Aguete
Date:
Subject: [URGENT] How to generata a unique string id