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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Unlinked files in PGDATA/base following unclean shutdown
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ALTER ROLE role-name-with-hyphen