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

NAME

6       END - commit the current transaction
7

SYNOPSIS

9       END [ WORK | TRANSACTION ]
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(7).
16

PARAMETERS

18       WORK
19       TRANSACTION
20           Optional key words. They have no effect.
21

NOTES

23       Use ROLLBACK(7) to abort a transaction.
24
25       Issuing END when not inside a transaction does no harm, but it will
26       provoke a warning message.
27

EXAMPLES

29       To commit the current transaction and make all changes permanent:
30
31           END;
32

COMPATIBILITY

34       END is a PostgreSQL extension that provides functionality equivalent to
35       COMMIT(7), which is specified in the SQL standard.
36

SEE ALSO

38       BEGIN(7), COMMIT(7), ROLLBACK(7)
39
40
41
42PostgreSQL 10.7                      2019                               END(7)