PostgreSQL: ERROR relation "users" does not exist for a table created as quoted "Users"
@aiden-f-dsouza▲ 7 net votes
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.