End
Ends the current transaction block and finalizes its modifications.
Synopsis
END [ WORK | TRANSACTION ]
Parameters
WORK | TRANSACTIONA pair of optional noise keywords. They can be ignored, or used to make your SQL more readable.
Results
COMMITThe message returned when a transaction is successfully committed.
NOTICE: COMMIT: no transaction in progressThe notice returned if there is no transaction in progress for the
ENDcommand to end.
Description
The END command is a synonym for COMMIT. Use it to
end transactions the same way you would use the COMMIT command.
Example
The following example demonstrates how to commit a transaction using the END command:
booktown=# END WORK;
COMMITGet Practical PostgreSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
