postgres: error: db doesnt exist ( psql create user case senstivity issue)

Question

I have this database triviaDB that i am connecting to from a flask-sqlalchemy 'postgresql://devuser:devpass@localhost:5432/triviaDB'however it's giving me a programing error psycopg2: auth not allowed.

so i use the following commands in psql to try and give devuser authorization on this database but here is the problem when i run GRANT ALL PRIVILEGES ON DATABASE triviaDB to devuser; iget this error: ERROR: database "triviadb" does not exist when i quote the db name GRANT ALL PRIVILEGES ON DATABASE 'triviaDB' TO devuser; i get this : ERROR: syntax error at or near "'triviaDB'"

yeah but then i get an error database doesnt exist(first one in the post), i can connect with postgres user ni problems. — Ahmed
– Ahmed, Commented Apr 12, 2020 at 22:19

JGH · Accepted Answer · 2020-04-13 09:59:57Z

1

If the DB name was created with upper cases, you need to use double quotes:

GRANT ALL PRIVILEGES ON DATABASE "triviaDB" to devuser;

answered Apr 13, 2020 at 9:59

JGH

18.2k5 gold badges40 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgres: error: db doesnt exist ( psql create user case senstivity issue)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related