postgresql16/END(7)

1END(7)                   PostgreSQL 16.1 Documentation                  END(7)
2
3
4

NAME

6       END - commit the current transaction
7

SYNOPSIS

9       END [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
10

DESCRIPTION

12       END commits the current transaction. All changes made by the
13       transaction become visible to others and are guaranteed to be durable
14       if a crash occurs. This command is a PostgreSQL extension that is
15       equivalent to COMMIT.
16

PARAMETERS

18       WORK
19       TRANSACTION
20           Optional key words. They have no effect.
21
22       AND CHAIN
23           If AND CHAIN is specified, a new transaction is immediately started
24           with the same transaction characteristics (see SET TRANSACTION
25           (SET_TRANSACTION(7))) as the just finished one. Otherwise, no new
26           transaction is started.
27

NOTES

29       Use ROLLBACK to abort a transaction.
30
31       Issuing END when not inside a transaction does no harm, but it will
32       provoke a warning message.
33

EXAMPLES

35       To commit the current transaction and make all changes permanent:
36
37           END;
38

COMPATIBILITY

40       END is a PostgreSQL extension that provides functionality equivalent to
41       COMMIT, which is specified in the SQL standard.
42