END
commit the current transaction
English manual coverage begins with PostgreSQL 6.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- anchor
- SQL-END
- file
- sql-end.html
- lang
- en
- name
- END
- purpose
- commit the current transaction
- purpose zh
- 提交当前事务
- sections same as
- Unknown
- slug
- 18
- synopsis html
- END [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
- synopsis text
- END [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
Syntax
END [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]Syntax diagrams
Read left to right. Branches are choices, bypasses are optional, loops repeat. Select an underlined parameter to open its rule.
Definition PG 18
END [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
Description
END commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs. This command is a PostgreSQL extension that is equivalent to COMMIT.
Parameters
WORKTRANSACTIONOptional key words. They have no effect.
AND CHAINIf
AND CHAINis specified, a new transaction is immediately started with the same transaction characteristics (see SET TRANSACTION) as the just finished one. Otherwise, no new transaction is started.
Notes
Use ROLLBACK to abort a transaction.
Issuing END when not inside a transaction does no harm, but it will provoke a warning message.
Examples
To commit the current transaction and make all changes permanent:
END;
Compatibility
END is a PostgreSQL extension that provides functionality equivalent to COMMIT, which is specified in the SQL standard.
See Also
BEGIN, COMMIT, ROLLBACKCompare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:1c07f74c7602cba455fb83fea101418f552705c0b0783542a5004dcc3d334560
Text language: en · wiki-repair-20261023:1c07f74c7602cba455fb83fea101418f552705c0b0783542a5004dcc3d334560