Problem Link to heading

I want to connect to a database ensuring that I cannot perform any write operations

Solution Link to heading

• Connect to a PostgreSQL server with psql or your graphical interface. This guide has only been tested with psql.

• Connect to the database you'd like to explore with \c dbname

• Run the following command:

  SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;
  

Related Link to heading

• https://stackoverflow.com/a/71023224
• https://www.postgresql.org/docs/15/sql-set-transaction.html