select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 7.0
Historical version. PostgreSQL 7.0 reached end of support in May 2005. See the current manual for supported releases.

END

Name

END — Commits the current transaction
END [ WORK | TRANSACTION ]
  

Inputs

WORK, TRANSACTION

Optional keywords. They have no effect.

Outputs

COMMIT

Message returned if the transaction is successfully committed.

NOTICE: COMMIT: no transaction in progress

If there is no transaction in progress.

Description

END is a Postgres 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.

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.