manpagez: man pages & more
man START_TRANSACTION(7)
Home | html | info | man
START TRANSACTION(7)     PostgreSQL 18.6 Documentation    START TRANSACTION(7)


NAME

       START_TRANSACTION - start a transaction block


SYNOPSIS

       START TRANSACTION [ transaction_mode [, ...] ]

       where transaction_mode is one of:

           ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
           READ WRITE | READ ONLY
           [ NOT ] DEFERRABLE


DESCRIPTION

       This command begins a new transaction block. If the isolation level,
       read/write mode, or deferrable mode is specified, the new transaction
       has those characteristics, as if SET TRANSACTION was executed. This is
       the same as the BEGIN command.


PARAMETERS

       Refer to SET TRANSACTION (SET_TRANSACTION(7)) for information on the
       meaning of the parameters to this statement.


COMPATIBILITY

       In the standard, it is not necessary to issue START TRANSACTION to
       start a transaction block: any SQL command implicitly begins a block.
       PostgreSQL's behavior can be seen as implicitly issuing a COMMIT after
       each command that does not follow START TRANSACTION (or BEGIN), and it
       is therefore often called "autocommit". Other relational database
       systems might offer an autocommit feature as a convenience.

       The DEFERRABLE transaction_mode is a PostgreSQL language extension.

       The SQL standard requires commas between successive transaction_modes,
       but for historical reasons PostgreSQL allows the commas to be omitted.

       See also the compatibility section of SET TRANSACTION
       (SET_TRANSACTION(7)).


SEE ALSO

       BEGIN(7), COMMIT(7), ROLLBACK(7), SAVEPOINT(7), SET TRANSACTION
       (SET_TRANSACTION(7))

PostgreSQL 18.6                      2026                 START TRANSACTION(7)

postgresql 18.6_0 - Generated Thu Aug 27 16:23:33 CDT 2026
© manpagez.com 2000-2026
Individual documents may contain additional copyright information.