SET AUTOCOMMIT

Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / 20devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1

Historical version. PostgreSQL 13 has reached end of support. 2025-11-13. See the current manual.

SET AUTOCOMMIT
Prev	Up	35.14. Embedded SQL Commands	Home	Next

SET AUTOCOMMIT — set the autocommit behavior of the current session

Synopsis

SET AUTOCOMMIT { = | TO } { ON | OFF }

Description

SET AUTOCOMMIT sets the autocommit behavior of the current database session. By default, embedded SQL programs are not in autocommit mode, so COMMIT needs to be issued explicitly when desired. This command can change the session to autocommit mode, where each individual statement is committed implicitly.

Compatibility

SET AUTOCOMMIT is an extension of PostgreSQL ECPG.

Prev	Up	Next
PREPARE	Home	SET CONNECTION

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.