DBA Hub

📋Steps in this guide1/1

Find autocommit setting in postgres

Bydefault autocommit is set to on in postgres. You can check the setting .

postgresql configurationintermediate
by PostgreSQL
28 views
1

Find autocommit setting in postgres

Bydefault autocommit is set to on in postgres. You can check the setting .

Code/Command (click line numbers to comment):

1
2
3
4
5
6
postgres#
\echo :AUTOCOMMIT;
ON;
At session level you can change the autocommit setting :
postgres#
\set AUTOCOMMIT OFF

Comments (0)

Please to add comments

No comments yet. Be the first to comment!