# Fix PostgreSQL 'relation does not exist' error

> 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.

Author: [Flavio Copes](https://flaviocopes.com/about/) | Published: 2022-05-15 | Topics: [Database](https://flaviocopes.com/tags/database/) | Canonical: https://flaviocopes.com/postgres-relation-not-exists/

If you have a [PostgreSQL](https://flaviocopes.com/postgres-introduction/) database and a table named **Car** for example and you try doing 

```sql
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:

```sql
SELECT * FROM "Car"
```
