escaping - sign

[Hugo Coolens]

I'm trying to accomplish the following:
GRANT all ON friends TO www-data;

however the - sign in www-data seems to be a problem, how should I
escape it correctly?

regards,
hugo

[Scott Auge]

In article <42***********************@news.skynet.be>,
Hugo Coolens <hu*********@skynet.be> wrote:

I'm trying to accomplish the following:
GRANT all ON friends TO www-data;

however the - sign in www-data seems to be a problem, how should I
escape it correctly?

regards,
hugo

Oofa - you should not use - in your table or field names.

You can try

GRANT ALL ON friends TO "www-data";

and see what that gets ya...

Let us know how it goes...

--
Available for Hire! http://amduus.com/Resumes/

[Hugo Coolens]

Scott Auge wrote:

In article <42***********************@news.skynet.be>,
Hugo Coolens <hu*********@skynet.be> wrote:

I'm trying to accomplish the following:
GRANT all ON friends TO www-data;

however the - sign in www-data seems to be a problem, how should I
escape it correctly?

regards,
hugo
Oofa - you should not use - in your table or field names.

in fact it is not a table or field name but a user name You can try

GRANT ALL ON friends TO "www-data";

and see what that gets ya...

this also does not work:
friends=> GRANT ALL ON friends to www-data;
ERROR: syntax error at or near "-" at character 28
friends=> GRANT ALL ON friends to "www-data";
ERROR: user "www-data" does not exist

In the past that user was wwwrun but on Debian Sarge it seems they
created a default user www-data ...I'd like to keep that user.

any help welcome
hugo
p.s. I'm trying out the tutorial at:
http://pgsql.designmagick.com/tutorial.php?id=4