Create a new database

new_db.sql

CREATE DATABASE db;
CREATE USER user WITH ENCRYPTED PASSWORD 'xxxx-oooo';
\c db;

GRANT ALL PRIVILEGES ON DATABASE db TO user;
GRANT USAGE ON SCHEMA public TO user ;

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO user;

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO user;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO user;