Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER ROLE role-name-with-hyphen - Mailing list pgsql-general

From Tom Copeland
Subject Re: ALTER ROLE role-name-with-hyphen
Date
Msg-id 395E648F-E4F3-4C6E-A1FA-170333A2E04B@infoether.com
Whole thread Raw
In response to Re: ALTER ROLE role-name-with-hyphen  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: ALTER ROLE role-name-with-hyphen
Next
From: Lennin Caro
Date:
Subject: Re: ALTER ROLE role-name-with-hyphen