---
title: "SET AUTOCOMMIT"
id: ecpg-sql-set-autocommit
pg_version: "20devel"
---

<a id="ecpg-sql-set-autocommit"></a>

# SET AUTOCOMMIT — set the autocommit behavior of the current session

## Synopsis

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

<a id="id-1.7.5.20.14.3"></a>

## 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. 

<a id="id-1.7.5.20.14.4"></a>

## Compatibility

`SET AUTOCOMMIT` is an extension of PostgreSQL ECPG.