1END()                            SQL Commands                            END()
2
3
4

NAME

6       END - commit the current transaction
7
8

SYNOPSIS

10       END [ WORK | TRANSACTION ]
11
12

DESCRIPTION

14       END  commits  the current transaction. All changes made by the transac‐
15       tion become visible to others and are guaranteed to  be  durable  if  a
16       crash occurs. This command is a PostgreSQL extension that is equivalent
17       to COMMIT [commit(7)].
18

PARAMETERS

20       WORK
21
22       TRANSACTION
23              Optional key words. They have no effect.
24

NOTES

26       Use ROLLBACK [rollback(7)] to abort a transaction.
27
28       Issuing END when not inside a transaction does no  harm,  but  it  will
29       provoke a warning message.
30

EXAMPLES

32       To commit the current transaction and make all changes permanent:
33
34       END;
35
36

COMPATIBILITY

38       END is a PostgreSQL extension that provides functionality equivalent to
39       COMMIT [commit(7)], which is specified in the SQL standard.
40

SEE ALSO

42       BEGIN [begin(7)], COMMIT [commit(l)], ROLLBACK [rollback(l)]
43
44
45
46SQL - Language Statements         2008-06-08                             END()