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.