On Saturday, July 25, 2015, Shreeyansh Dba <shreeyansh2014(at)gmail(dot)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.
>
>