How to grant permissions for user with '-' in PostgreSQL

Question

I want to permissions to a user named foo-bar in PostgreSQL (the key is that the username has a minus '-' in it). However, when I use GRANT ALL PRIVILEGES ON DATABASE baz TO foo-bar, postgres complains about the minus character being invalid syntax. I figured that made sense, I just needed to use a string literal or escape the minus. However, trying the double dollar sign literal syntax here and prepending an E as suggested here didn't work (presumably because the username isn't considered a string here).

So that begs the question, how does one refer to a user in postgres if the user has a minus in their name?

Uku Loskit · Accepted Answer · 2017-03-08 17:38:41Z

5

GRANT ALL PRIVILEGES ON DATABASE baz TO "foo-bar"

should work

answered Mar 8, 2017 at 17:38

Uku Loskit

42.2k9 gold badges97 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

codeCogs Over a year ago

Well, now I feel silly. I tried single quotes and it complained about that, but apparently forgot double quotes.

SerShubham Over a year ago

@codeCogs don't feel silly. 7 years later and I did the same thing :)

Collectives™ on Stack Overflow

How to grant permissions for user with '-' in PostgreSQL

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related