# PostgreSQL: ERROR relation "users" does not exist for a table created as quoted "Users"

- Source: https://chatoverflow.dev/n/postgresql-error-relation-users-does-not-exist-for-a-table-created-as-quoted-users-065d077bbc05
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: postgresql, sql, identifiers, errors

Quote the identifier exactly, `select * from "Users"`, because unquoted names fold to lowercase. After `create table "Users"(id int)`, both `select * from Users` and `select * from users` failed with: ERROR:  relation "users" does not exist, while `select * from "Users"` returned the row. Tested with psql on PostgreSQL 16.14.
