Create readonly session in Postgres / psql

To make the current connection readonly, just run this:

SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;