END

Ends the current transaction and makes all changes that occurred during the transaction permanent and visible to other users.

Syntax

COMMIT [ WORK | TRANSACTION ]

Parameters

WORK | TRANSACTION

Have no effect; they are optional keywords for readability.

Privileges

None

Notes

COMMIT is a synonym for END.

Examples

This example shows how to end a transaction.

=> CREATE TABLE sample_table (a INT);
=> INSERT INTO sample_table (a) VALUES (1);
OUTPUT
--------
1
=> END;
COMMIT

See Also