PostgreSQL Documentation: transaction_read

Type:	`bool`
Default:	`off`
Context:	`user`
Restart:	`false`
Since:	`9.6`

Sets the current transaction's read-only status

This parameter reflects the current transaction's read-only status. At the beginning of each transaction, it is set to the current value of default_transaction_read_only. Any subsequent attempt to change it is equivalent to a sql-set-transaction command.

Official docs

Search in source code

Recommendations

Sets the current transaction to read only. Useful as part of a SQL injection prevention program. Shows as TRUE on replication standbys.

By annotated.conf

On StackOverflow

What exactly means the collation 'de-DE-u-kn-true'
Lazily (de-)serialize JSON with EF Core
Connect to a heroku database with pgadmin
Get breakdown from de-normalized SQL table
PostGIS & Hibernate can't de-serialize point geometry

On pgsql-hackers

is there any specific use of setting transaction_read_only GUC externally?
Read-only connection mode for AI workflows.
Re: display hot standby state in psql prompt

transaction_read_only

Recommendations

On StackOverflow

On pgsql-hackers

Comments