Re: Valid role name (PostgreSQL 9.0.4) - Mailing list pgsql-novice

From Josh Kupershmidt
Subject Re: Valid role name (PostgreSQL 9.0.4)
Date
Msg-id BANLkTi=1P+sfgaR9K4fq59DCmeHpy1faPw@mail.gmail.com
Whole thread Raw
In response to Valid role name (PostgreSQL 9.0.4)  (Grzegorz Szpetkowski <gszpetkowski@gmail.com>)
Responses Re: Valid role name (PostgreSQL 9.0.4)
List pgsql-novice
On Thu, Apr 7, 2011 at 11:21 PM, Grzegorz Szpetkowski
<gszpetkowski@gmail.com> wrote:
> Then I run:
>
> psql -c "ALTER ROLE user CREATEDB"
> ERROR:  syntax error at or near "user"
> LINE 1: ALTER ROLE user CREATEDB
>                  ^

If you quote the "user" username like so:

ALTER ROLE "user" CREATEDB;

the command should work as you expected it to.

Josh

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Superuser accout (PostgreSQL 9.0.4)
Next
From: Mathieu Dubois
Date:
Subject: Re: What does \timing measure?