Can't query my DB with SQL EDITOR
Hi everybody !
I'm so confused to not be able to query my DB with SQL EDITOR tool.
Each time I try to query a table which exists in my DB (as you can see in the picture), I have the same error message "ERROR: relation "categorie" does not exist (SQLSTATE 42P01)"...
6 Replies
deep-jadeOP•2y ago
national-gold•2y ago
This is a case issue. Try quoting your table and column names. Postgres will fold names to lowercase otherwise.
deep-jadeOP•2y ago
So I should query like that : SELECT * FROM "categorie" ?
Thank you to spend your time to help me so quickly !
national-gold•2y ago
Hey, in your case, SELECT * FROM "Categorie" should work.
deep-jadeOP•2y ago
Thank you so much, I feel like a Rookie
national-gold•2y ago
Not at all! This question has come up more than a few times. The way I like to think about it is that Postgres goes lowercase when you create objects or run query unless you tell it otherwise by using quotes.