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