top of page
CerebroSQL

PostgreSQL:  

RELEASE SAVEPOINT

RELEASE [ SAVEPOINT ] savepoint_name

Example

BEGIN;
INSERT INTO table1 VALUES (3);
SAVEPOINT my_savepoint;
INSERT INTO table1 VALUES (4);
RELEASE SAVEPOINT my_savepoint;
COMMIT;

bottom of page