[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: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit postgres=# ALTER USER foo-bar WITH ENCRYPTED PASSWORD 'foo-bar'; ERROR: syntax error at or near - LINE 1: ALTER USER foo-bar WITH ENCRYPTED PASSWORD 'foo-bar'; ^ == So I can create the role but I can't figure out how to modify it. I've tried a variety of quoting and backslashing and such, but no luck yet any ideas? Thanks, Tom -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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 lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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 manual ... Argh I could have sworn I tried that... awesome, that works great, thanks much! Yours, Tom -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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-general@postgresql.org Date: Friday, August 8, 2008, 8:49 PM 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: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit postgres=# ALTER USER foo-bar WITH ENCRYPTED PASSWORD 'foo-bar'; ERROR: syntax error at or near - LINE 1: ALTER USER foo-bar WITH ENCRYPTED PASSWORD 'foo-bar'; ^ == So I can create the role but I can't figure out how to modify it. I've tried a variety of quoting and backslashing and such, but no luck yet any ideas? Thanks, Tom -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general