ABORT [ WORK | TRANSACTION ]
A pair of optional noise keywords. They can be ignored, or used to make your SQL more readable.
The message returned when an ABORT completes successfully.
The notice returned if the database server is unable to find any transaction in progress.
The following example demonstrates the use of ABORT to undo an accidental DELETE command:
booktown=# BEGIN WORK; BEGIN booktown=# DELETE FROM publishers WHERE id < 100; DELETE 6 booktown=# ABORT WORK; ROLLBACK
