Posted on July 18, 2016 by garyCreate readonly session in Postgres / psql To make the current connection readonly, just run this: SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;