CREATE TABLE users( id SERIAL NOT NULL PRIMARY KEY, username VARCHAR(50) NOT NULL, secret VARCHAR(255) NOT NULL, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW() ); CREATE TRIGGER set_timestamp BEFORE UPDATE ON users FOR EACH ROW EXECUTE PROCEDURE trigger_set_timestamp(); ---- create above / drop below ---- DROP TABLE users;