Re: Valid role name (PostgreSQL 9.0.4)

On Thu, Apr 7, 2011 at 11:21 PM, Grzegorz Szpetkowski
<gszpetkowski(at)gmail(dot)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