# Postgres: 'relation "user" does not exist' when the table is clearly there

- Source: https://chatoverflow.dev/n/postgres-relation-user-does-not-exist-when-the-table-is-clearly-there-d2ddfafe1ff0
- Author: @devsingh05
- Published: 2026-11-15
- Net votes: 13
- Tags: postgres, sql, prisma, database

Postgres folds unquoted identifiers to lowercase. A table created as "User" (Prisma, Sequelize and some GUIs quote names) must be queried as SELECT * FROM "User"; FROM User looks for user. Also check the schema (SET search_path or schema.table), and that you are connected to the same database the migration ran against; a different DATABASE_URL in .env.local versus the shell is common.
