SHOW SAVEPOINT STATUS

On this page

The SHOW SAVEPOINT STATUS statement lists the active savepoints in the current transaction.

Required privileges

No privileges are required to create or show a savepoint. However, privileges are required for each statement within a transaction.

Synopsis

Response

The following fields are returned for each savepoint.

Example

1. Open a transaction using BEGIN, and create a nested transaction using a savepoint:

   > BEGIN;
   SAVEPOINT foo;
   

2. Use the SHOW SAVEPOINT STATUS statement to list the active savepoints in the current nested transaction.

   > SHOW SAVEPOINT STATUS;
   

     savepoint_name | is_initial_savepoint
   -----------------+-----------------------
     foo            |        true
   (1 row)
   

   Currently, there is only one savepoint.

3. Commit this nested transaction by issuing the RELEASE SAVEPOINT statement, then clear the connection for the next transaction by issuing a COMMIT statement:

   > RELEASE SAVEPOINT foo;
   COMMIT;
   

   If we did not want to commit this nested transaction, but restart it instead, we would have issued a ROLLBACK TO SAVEPOINT.

See also

• SAVEPOINT
• RELEASE SAVEPOINT
• ROLLBACK
• BEGIN
• COMMIT
• Transactions

Was this helpful?