Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: ALTER ROLE role-name-with-hyphen
Date
Msg-id 18650.1218229056@sss.pgh.pa.us
Whole thread Raw
In response to ALTER ROLE role-name-with-hyphen  (Tom Copeland <tom@infoether.com>)
Responses Re: ALTER ROLE role-name-with-hyphen  (Tom Copeland <tom@infoether.com>)
List pgsql-general
Tree view 
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 ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Copeland
Date:
Subject: ALTER ROLE role-name-with-hyphen
Next
From: Tom Copeland
Date:
Subject: Re: ALTER ROLE role-name-with-hyphen