COMMIT [ WORK | TRANSACTION ]
A pair of optional noise keywords. They can be ignored, or used to make your SQL more readable.
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.
Note: If something unintended happens during a transaction block, you can use the ROLLBACK command to abort the current transaction. This undoes the effect of any SQL executed after the last BEGIN statement.
The following example begins a transaction, modifies data, and then commits the modifications:
booktown=# BEGIN WORK; BEGIN booktown=# INSERT INTO employees VALUES (106, 'Hall', 'Timothy'); INSERT 3574402 1 booktown=# COMMIT WORK; COMMIT