September 26, 2024: PostgreSQL 17 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

END

Name

END  --  commit the current transaction

Synopsis

END [ WORK | TRANSACTION ]
  

Inputs

WORK
TRANSACTION

Optional keywords. They have no effect.

Outputs

COMMIT

Message returned if the transaction is successfully committed.

WARNING: COMMIT: no transaction in progress

If there is no transaction in progress.

Description

END is a PostgreSQL extension, and is a synonym for the SQL92-compatible COMMIT.

Notes

The keywords WORK and TRANSACTION are noise and can be omitted.

Use ROLLBACK to abort a transaction.

Usage

To make all changes permanent:

END WORK;
   

Compatibility

SQL92

END is a PostgreSQL extension which provides functionality equivalent to COMMIT.