You need to user is a reserved word so you need to quote it (ie:
"user" rather than user) whenever you reference it.Does group reader exist?
If it does then it might be a case issue as presumably you must have quoted
user user to create it which also preserves case, so if you did the same
Jari Aalto writes:
> class=# \i pg-def-group-grant.sql
> Granting ALL to ROOT
> CHANGE
> Granting ALL to USER
> psql:pg-def-group-grant.sql:48: ERROR: parser: parse error at or near "user"
You need to double quote "user". It's a reserved word.
> Granting SELECT to READER
> psql:pg-def-group-g
Jari Aalto wrote:
>
>Can anyone suggest, what is wrong with the following
>sql file? SOmehow the semicolon causes error?
...
>Granting ALL to USER
>psql:pg-def-group-grant.sql:48: ERROR: parser: parse error at or near "user
>"
...
>32:GRANT ALL ON
>33: bonus
>34: ,
