COMMIT [ WORK | TRANSACTION ]
Use the COMMIT command to finalize the current transaction. Once a COMMIT is performed, any modifications made by the transaction are saved into the database.
|The ROLLBACK Command|
You can use the ROLLBACK command to abort the current transaction, instead of committing.
The following example begins a transaction, modifies data, then commits the modifications.
booktown=# BEGIN WORK; BEGIN booktown=# INSERT INTO employees VALUES (106, 'Hall', 'Timothy'); INSERT 3574402 1 booktown=# COMMIT WORK; COMMIT