2 doc/src/sgml/ref/end.sgml
3 PostgreSQL documentation
6 <refentry id="SQL-END">
8 <refentrytitle>END</refentrytitle>
9 <manvolnum>7</manvolnum>
10 <refmiscinfo>SQL - Language Statements</refmiscinfo>
14 <refname>END</refname>
15 <refpurpose>commit the current transaction</refpurpose>
18 <indexterm zone="sql-end">
19 <primary>END</primary>
24 END [ WORK | TRANSACTION ]
29 <title>Description</title>
32 <command>END</command> commits the current transaction. All changes
33 made by the transaction become visible to others and are guaranteed
34 to be durable if a crash occurs. This command is a
35 <productname>PostgreSQL</productname> extension
36 that is equivalent to <xref linkend="sql-commit">.
41 <title>Parameters</title>
45 <term><literal>WORK</literal></term>
46 <term><literal>TRANSACTION</literal></term>
49 Optional key words. They have no effect.
60 Use <xref linkend="SQL-ROLLBACK"> to
65 Issuing <command>END</> when not inside a transaction does
66 no harm, but it will provoke a warning message.
71 <title>Examples</title>
74 To commit the current transaction and make all changes permanent:
77 </programlisting></para>
81 <title>Compatibility</title>
84 <command>END</command> is a <productname>PostgreSQL</productname>
85 extension that provides functionality equivalent to <xref
86 linkend="sql-commit">, which is
87 specified in the SQL standard.
92 <title>See Also</title>
94 <simplelist type="inline">
95 <member><xref linkend="sql-begin"></member>
96 <member><xref linkend="sql-commit"></member>
97 <member><xref linkend="sql-rollback"></member>