Name
END -- Ends the current transaction block and finalizes its modifications.
Synopsis
END [ WORK | TRANSACTION ]
Parameters
- WORK | TRANSACTION
A pair of optional noise keywords. They can be ignored, or used to make your SQL more readable.
Results
- COMMIT
The message returned when a transaction is successfully committed.
- NOTICE: COMMIT: no transaction in progress
The notice returned if there is no transaction in progress for the END command 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;
COMMIT