Dbms transaction (psql)

BEGIN;
UPDATE accounts SET balance = balance - 100.00
    WHERE name = 'Alice';
SAVEPOINT my_savepoint;
UPDATE accounts SET balance = balance + 100.00
    WHERE name = 'Bob';
-- oops ... forget that and use Wally's account
ROLLBACK TO my_savepoint;
UPDATE accounts SET balance = balance + 100.00
    WHERE name = 'Wally';
COMMIT;

Source: postgresql.org

Similar codes

0 vote146 views1 answer
What is top n result in sql
SQL
0 vote141 views2 answers
T sql null or empty string
SQL
1 vote143 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
8 votes141 views2 answers
Oracle undo usage
SQL
1 vote133 views1 answer
Postgres check blocking
SQL
1 vote143 views1 answer
Sql week commencing date
SQL
0 vote154 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
2 votes157 views2 answers
Mysql does sentence contain word
SQL
0 vote145 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote172 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL