Create read only user on Postgres

GRANT SELECT ON ALL TABLES IN SCHEMA public TO username;

ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT ON TABLES TO username;