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";