1 2 3 4 5 6 7 8 9 10 11
-- name: drop-table-person DROP TABLE IF EXISTS "person"; -- name: create-table-person CREATE TABLE "person" (id SERIAL PRIMARY KEY, name VARCHAR NOT NULL, data BYTEA); -- name: insert-person INSERT INTO "person" (name, data) VALUES ($1, $2); -- name: select-all SELECT id, name, data FROM person;