Contents
BEGIN
An SQL command for starting a transaction block
BEGIN is a transaction command for starting a transaction block. It is equivalent to the SQL standard START TRANSACTION command.
BEGIN has always been present in PostgreSQL.
Usage
One of the following transaction isolation levels can optionally be specified:
READ COMMITTEDREAD UNCOMMITTEDREPEATABLE READSERIALIZABLE
READ COMMITTED is the default.
Examples
Basic execution example for BEGIN:
postgres=# BEGIN; BEGIN
A WARNING will be emitted if BEGIN is executed inside an existing transaction:
postgres=# BEGIN; BEGIN postgres=*# BEGIN; WARNING: there is already a transaction in progress BEGIN
References
- PostgreSQL documentation: BEGIN