richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com> writes:
> grant create, usage on schema {schema_name} to {role};
> fails with the error:
> ERROR: syntax error at or near "{role}"
> but by changing the capitalization of the statement to:
> GRANT CREATE, USAGE ON SCHEMA {schema_name} TO {role};
> completes successfully.
What are you expecting will replace "{role}" with something
valid? Whatever that is is apparently somehow dependent
on the context being upper-case.
regards, tom lane