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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general