| From: | Tom Copeland <tom(at)infoether(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | ALTER ROLE role-name-with-hyphen |
| Date: | 2008-08-08 20:49:26 |
| Message-ID: | 3C453B30-93F6-4C4D-A8D9-C6BF3535E5AC@infoether.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-08-08 20:57:36 | Re: ALTER ROLE role-name-with-hyphen |
| Previous Message | Tom Lane | 2008-08-08 20:42:16 | Re: Unlinked files in PGDATA/base following unclean shutdown |