The pg_read_all_data role in PostgreSQL provides read-only access to all tables and views without granting explicit permissions on each object. It is available from Postgres 14. See Predefined Roles.

GRANT pg_read_all_data TO <your_user>

Added with commit.