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

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:

commit;
commit work;
commit transaction;

On this page: