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