| From: | Doug McNaught <doug(at)wireboard(dot)com> |
|---|---|
| To: | Sean Chittenden <sean-pgsql-general(at)chittenden(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Username with a hyphen character (grant failing?) |
| Date: | 2001-05-25 15:38:50 |
| Message-ID: | m3r8xde8vp.fsf@belphigor.mcnaught.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Sean Chittenden <sean-pgsql-general(at)chittenden(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arcady Genkin | 2001-05-25 15:51:26 | Compilation fails --with-ssl on Solaris 8 |
| Previous Message | Len Morgan | 2001-05-25 15:27:46 | Re: COPY with default values? |