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

From Doug McNaught
Subject Re: Username with a hyphen character (grant failing?)
Date
Msg-id m3r8xde8vp.fsf@belphigor.mcnaught.org
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?)  (will trillich <will@serensoft.com>)
List pgsql-general
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.
>
>     Are single quotes treated differently than double?  I tried
> single, but didn't have any luck...  -sc

Yes.  Single quotes are for strings; double quotes are for
identifiers.

-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time...          --Dylan

pgsql-general by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: Username with a hyphen character (grant failing?)
Next
From: "Len Morgan"
Date:
Subject: Re: COPY with default values?