Re: Username with a hyphen character (grant failing?)

On Fri, May 25, 2001 at 11:38:50AM -0400, Doug McNaught wrote:
> 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.

meaning, for example:

create table info (
"this field" text,
"that-field" integer,
"it's alarming" serial
);
insert into info("this-field")values('here\'s the contents for that column in the table');

or

grant select on "table named with spaces" to "some-oddball-user";

select 'this is a string value, not a field or table name';

--
#95: We are waking up and linking to each other. We are watching. But
we are not waiting. -- www.cluetrain.com

will(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!