Herbert Liechti 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
Double-quotes:
test=> GRANT SELECT, UPDATE, INSERT, DELETE ON test TO "www-data";
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
