This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
SET AUTOCOMMIT
Name
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.