ALTER ROLE role-name-with-hyphen
От | Tom Copeland |
---|---|
Тема | ALTER ROLE role-name-with-hyphen |
Дата | |
Msg-id | 3C453B30-93F6-4C4D-A8D9-C6BF3535E5AC@infoether.com обсуждение исходный текст |
Ответы |
Re: ALTER ROLE role-name-with-hyphen
Re: ALTER ROLE role-name-with-hyphen |
Список | pgsql-general |
Hi all - This is probably a new bee question... but, how do I change the password of a role that has a hyphen in the name? ====================== $ createuser --no-superuser --createdb --no-createrole foo-bar $ psql Welcome to psql 8.3.0, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit postgres=# ALTER USER foo-bar WITH ENCRYPTED PASSWORD 'foo-bar'; ERROR: syntax error at or near "-" LINE 1: ALTER USER foo-bar WITH ENCRYPTED PASSWORD 'foo-bar'; ^ ====================== So I can create the role but I can't figure out how to modify it. I've tried a variety of quoting and backslashing and such, but no luck yet.... any ideas? Thanks, Tom
В списке pgsql-general по дате отправления: