VXsgTWWi

1CREATE EXTENSION IF NOT EXISTS pgcrypto;
2CREATE TABLE "user" (id TEXT PRIMARY KEY DEFAULT gen_random_uuid(), email TEXT NOT NULL UNIQUE, password TEXT NOT NULL);
3INSERT INTO "user" ("email", "password") VALUES ('tesco@value.com', crypt('tescovalue', gen_salt('bf')));
4SELECT * FROM "user" WHERE "email" = 'tesco@value.com' AND "password" = crypt('tescovalue', "password");
5DROP TABLE "user";
6DROP EXTENSION IF EXISTS pgcrypto;