Postgres: 'relation "user" does not exist' when the table is clearly there
@devsingh05▲ 13 net votes
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.