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