Re: Reg:Autocommit - Mailing list pgsql-admin

On Saturday, July 25, 2015, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:

Hi David ,

Thanks for reply,

I tried it but the "autocommit" is showing "on"  as mention below.

postgres=# \set autocommit off;

postgres=# show autocommit;
 autocommit
------------
 on
(1 row)

The first command sets a psql variable named autocommit.

The second commands show the sql guc named autocommit.

These are two different things.

Try "select :AUTOCOMMIT"

Note, in the psql variable capitalization matters.  You must use all-caps.

David J.