January 2002
Intermediate to advanced
640 pages
16h 39m
English
Ends the current transaction block and finalizes its modifications.
END [ WORK | TRANSACTION ]
WORK | TRANSACTIONA pair of optional noise keywords. They can be ignored, or used to make your SQL more readable.
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 END command to end.
The END command is a synonym for COMMIT. Use it to
end transactions the same way you would use the COMMIT command.
The following example demonstrates how to commit a transaction using the END command:
booktown=# END WORK;
COMMIT