Postgresql transaction

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

12 votes185 views6 answers
Select distinct
SQL
0 vote177 views1 answer
Min mysql
SQL
1 vote182 views1 answer
Pl sql ptint
SQL
0 vote185 views1 answer
Add timestamp column to existing table t-sql
SQL
1 vote166 views1 answer
Oracle rolling back
SQL
2 votes207 views1 answer
Python sql
SQL
1 vote196 views1 answer
Sql select max value from multiple rows
SQL
0 vote187 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote210 views1 answer
Permission denied postgres \copy csv command line
SQL
6 votes190 views2 answers
Sql display max value
SQL