CREATE ROLE admin WITH LOGIN PASSWORD 'Sup3rS3cretPass!'; CREATE TABLE widgets ( id SERIAL PRIMARY KEY, name TEXT NOT NULL );