Re: ALTER ROLE role-name-with-hyphen

From: Tom Copeland <tom(at)infoether(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ALTER ROLE role-name-with-hyphen
Date: 2008-08-08 21:09:13
Message-ID: 395E648F-E4F3-4C6E-A1FA-170333A2E04B@infoether.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Aug 8, 2008, at 4:57 PM, Tom Lane wrote:

> Tom Copeland <tom(at)infoether(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lennin Caro 2008-08-08 21:24:21 Re: ALTER ROLE role-name-with-hyphen
Previous Message Tom Lane 2008-08-08 20:57:36 Re: ALTER ROLE role-name-with-hyphen