COMMIT -- Ends the current transaction block and finalizes changes made within it.
COMMIT [ WORK | TRANSACTION ]
WORK | TRANSACTION
A pair of optional noise keywords. They can be ignored, or used to make your SQL more readable.
The message returned when the current transaction is successfully committed.
NOTICE: COMMIT: no transaction in progress
The notice returned if there is no current transaction for the COMMIT command to actually commit.
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;
booktown=# INSERT INTO employees VALUES (106, 'Hall', 'Timothy');
INSERT 3574402 1
booktown=# COMMIT WORK;