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
COMMITcommand to actually commit.
COMMIT command to finalize the current transaction. Once a
COMMIT is performed, any modifications made by the transaction are saved
into the database.
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
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