2023-04-13
TIL PostgreSQL
TIL: use double quotes for postgresql table name that is not all lowercase
Made postgresql database table from prisma schema
-- schema.prisma
model School {
...
}
-- equivalent sql
CREATE TABLE "School" (
...
);
Error when tried to query the database
schools=# select * from School;
ERROR: relation "school" does not exist
LINE 1: select * from School;
^
Fix
-- before
select * from School;
-- after
select * from "School";