COMMIT - Amazon Redshift

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. This keyword isn't supported within a stored procedure.

TRANSACTION

Optional keyword. WORK and TRANSACTION are synonyms. Neither is supported within a stored procedure.

For information about using COMMIT within a stored procedure, see Managing Transactions.

Examples

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

commit;
commit work;
commit transaction;