Kakoli Sen wrote:
> The command GRANT ALL PRIVILEGES ON DATABASE casDatabase to tester;
> is giving error:
> ERROR: database "casdatabase" does not exist.(Note that the db name in error is all in lower case).
>
> Also \l shows that casDatabase exists.
> Why is 'casDatabase' being changed to 'casdatabase'?
PostgreSQL will convert all names to lower case unless you protect them with
double quotes.
Try:
GRANT ALL PRIVILEGES ON DATABASE "casDatabase" to tester;
Yours,
Laurenz Albe