top of page
CerebroSQL

PostgreSQL:  

SAVEPOINT

SAVEPOINT savepoint_name

Example

BEGIN;
INSERT INTO table1 VALUES (1);
SAVEPOINT my_savepoint;
INSERT INTO table1 VALUES (2);
ROLLBACK TO SAVEPOINT my_savepoint;
INSERT INTO table1 VALUES (3);
COMMIT;

bottom of page