END
Ends the current transaction and makes all changes that occurred during the transaction permanent and visible to other users.
COMMIT is a synonym for END.
Syntax
END [ WORK | TRANSACTION ]
Parameters
WORK | TRANSACTION |
Optional keywords that have no effect, for readability only. |
Privileges
None
Examples
=> BEGIN TRANSACTION ISOLATION LEVEL READ COMMITTED READ WRITE; BEGIN => CREATE TABLE sample_table (a INT); CREATE TABLE => INSERT INTO sample_table (a) VALUES (1); OUTPUT -------- 1 (1 row) => END; COMMIT