Name

SAVEPOINT — define a new savepoint within the current transaction

Synopsis

SAVEPOINT savepoint_name

Notes

Use ROLLBACK TO SAVEPOINT(7) to rollback to a savepoint. Use RELEASE SAVEPOINT(7) to destroy a savepoint, keeping the effects of commands executed after it was established.

Savepoints can only be established when inside a transaction block. There can be multiple savepoints defined within a transaction.