Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / 20devel

Unsupported versions: 13 / 12 / 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

Historical version. PostgreSQL 9.5 has reached end of support. 2021-02-11. See the current manual.

ROLLBACK

Name

ROLLBACK -- abort the current transaction

ROLLBACK [ WORK | TRANSACTION ]

ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded.

Use COMMIT to successfully terminate a transaction.

Issuing ROLLBACK outside of a transaction block emits a warning and otherwise has no effect.

To abort all changes:

ROLLBACK;

The SQL standard only specifies the two forms ROLLBACK and ROLLBACK WORK. Otherwise, this command is fully conforming.

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