Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

COMMIT

Commits the current transaction to the database. This command makes the database updates from the transaction permanent.

Syntax

Copy
COMMIT [ WORK | TRANSACTION ]

Parameters

WORK

Optional keyword.

TRANSACTION

Optional keyword; WORK and TRANSACTION are synonyms.

Examples

Each of the following examples commits the current transaction to the database:

Copy
commit;

Copy
commit work;

Copy
commit transaction;