Re: [GENERAL] ALTER ROLE role-name-with-hyphen

use the double quotes (") ALTER USER "foo-bar" WITH ENCRYPTED PASSWORD 'foo-bar' --- On Fri, 8/8/08, Tom Copeland <[EMAIL PROTECTED]> wrote: > From: Tom Copeland <[EMAIL PROTECTED]> > Subject: [GENERAL] ALTER ROLE role-name-with-hyphen > To: pgsql

Re: [GENERAL] ALTER ROLE role-name-with-hyphen

On Aug 8, 2008, at 4:57 PM, Tom Lane wrote: Tom Copeland <[EMAIL PROTECTED]> 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 manu

Re: [GENERAL] ALTER ROLE role-name-with-hyphen

Tom Copeland <[EMAIL PROTECTED]> 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

[GENERAL] ALTER ROLE role-name-with-hyphen

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: \copyrigh