How to fix PostgreSQL saying "relation does not exist"
New Courses Coming Soon
Join the waiting lists
A quick explanation of how to solve PostgreSQL saying relation does not exist
If you have a PostgreSQL database and a table named Car for example and you try doing
SELECT * FROM Car
you’ll see an error saying
Query 1 ERROR: ERROR: relation "car" does not exist
LINE 1: SELECT * FROM Car
One issue might be the table actually does not exist.
But if it does, this error appears because PostgreSQL raises errors on tables with mixed cases.
Use this syntax instead:
SELECT * FROM "Car"
→ Read my SQL Tutorial on
The Valley of Code
Here is how can I help you:
- COURSES where I teach everything I know
- CODING BOOTCAMP cohort course - next edition in 2025
- BOOKS 16 coding ebooks you can download for free on JS Python C PHP and lots more
- Follow me on X