Postgres setting autocommit off globally

autocommit, postgresql, transactions

Solution

Simply add the following to `~/.psqlrc`:

\set AUTOCOMMIT off

Note that this only works when using the `psql` shell! I assume this is what you are talking about?

Problem

How do you set autocommit off in psql 8.4 at a global level? is there a configuration attribute that i can change that will introduce this behaviour for all dbs on a cluster to start db sessions with autocommit off?

Original source