Create A Postgres User with read-only Access

CREATE ROLE readonlyaccount LOGIN PASSWORD 'your-password-here';
GRANT SELECT ON ALL TABLES IN SCHEMA public to readonlyaccount;
GRANT CONNECT ON DATABASE database_name to readonlyaccount;