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