Re: ALTER ROLE role-name-with-hyphen

Поиск
Список
Период
Сортировка
От Tom Copeland
Тема Re: ALTER ROLE role-name-with-hyphen
Дата
Msg-id 395E648F-E4F3-4C6E-A1FA-170333A2E04B@infoether.com
обсуждение исходный текст
Ответ на Re: ALTER ROLE role-name-with-hyphen  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Aug 8, 2008, at 4:57 PM, Tom Lane wrote:

> Tom Copeland <tom@infoether.com> writes:
>> This is probably a new bee question... but, how do I change the
>> password of a role that has a hyphen in the name?
>
> You need double quotes, not single quotes.  Read about SQL identifier
> syntax in the fine manual ...

Argh.... I could have sworn I tried that... awesome, that works great,
thanks much!

Yours,

Tom


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ALTER ROLE role-name-with-hyphen
Следующее
От: Lennin Caro
Дата:
Сообщение: Re: ALTER ROLE role-name-with-hyphen