Re: Wanted: Trick for granting permissions to users with hyphens - Mailing list pgsql-general

On Wed, Nov 19, 2003 at 16:48:49 +0100,
  Herbert Liechti <herbie@thinx.ch> wrote:
> Hello
>
> I like to grant some permissions to the user www-data (default user
> for apache under debian)
>
> GRANT SELECT, UPDATE, INSERT, DELETE ON customer TO herbie, www-data;
>
> The statements throws the following error:
> ERROR:  parser: parse error at or near "-" at character 64
>
> Seems to me that hyphens are not allowed for user names. But a »createuser
> www-data« is working correct an I can access the database with that
> user.
>
> I tried to quote the www-data with 'www-data', www\-data with
> the same result.
>
> Any hints? I'm using 7.3.2

Single quotes are for data; use double quotes for including special characters
in names.