"\set AUTOCOMMIT off" has affect

Axel Straschil writes:

I want to disable autocommit, my psqlrc:

SET client_min_messages = 'WARNING';
SET add_missing_from = false;
\set AUTOCOMMIT off

it has no effect:

echo "show AUTOCOMMIT" | psql
SET
SET
autocommit
------------
on
(1 row)

How can I disable autocommit in psqlrc?

It is. You're just looking at the no-op GUC variable instead of the
psql one. Try

\echo :AUTOCOMMIT

instead.

regards,
andreas
--

Hallo!

It is. You're just looking at the no-op GUC variable instead of the
psql one. Try
\echo :AUTOCOMMIT
instead.

Oh, your right, just tested, it is ;-)

Thanks,
AXEL.