Contents
ABORT
An SQL command for rolling back the current transaction
ABORT is a transaction command for rolling back the current transaction.
ABORT has always been present in PostgreSQL.
Usage
ABORT is functionally equivalent to the SQL standard ROLLBACK command and has been retained for historical reasons.
Change history
- PostgreSQL 12
[ AND [ NO ] CHAIN ]syntax added (commit 280a408b)
Examples
Basic execution of ABORT:
postgres=# BEGIN;
BEGIN
postgres=*# SELECT 1;
?column?
----------
1
(1 row)
postgres=*# ABORT;
ROLLBACK
References
- PostgreSQL documentation: ABORT