I'm using postgres 9.5. How can I check if auto commit is on or off? I tried SHOW AUTOCOMMIT
where I got ERROR: unrecognized configuration parameter "autocommit"
then I did a \set autocommit off
and then SHOW AUTOCOMMIT
gives me blank output. How can identify if autocommit is on or off? Also can I set it to off while/after the database in created in my sql file?
How to check if autocommit is on or not postgres' psql
37.8k views Asked by codec At
3
According to this Dustin Marx article, you can use: