Name
COMMIT
-- Ends the current transaction block and finalizes changes made within it.
Synopsis
COMMIT [ WORK | TRANSACTION ]
Parameters
- WORK, TRANSACTION
These keywords are non-functional. You can ignore them.
Results
- COMMIT
This message is displayed if the current transaction is successfully
committed.
- NOTICE: COMMIT: no transaction in progress
This message is displayed if there is no current transaction for
the COMMIT command to work with.
Description
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.
|
Examples
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