Fix PostgreSQL 'relation does not exist' error

May 15, 2022

Learn how to fix the PostgreSQL relation does not exist error, which happens with mixed-case table names, by quoting the table name like Car in your query.

~~~

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"

Tagged: Database · All topics

~~~