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

0 vote189 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote173 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote176 views1 answer
Mysql milliseconds
SQL
0 vote163 views1 answer
How to check if there is no database schema
SQL
0 vote168 views1 answer
Add sqlite3 in lumen
SQL
0 vote179 views1 answer
Adding generated time in row mysql workbench
SQL
0 vote177 views1 answer
Get primary key of table
SQL
1 vote163 views1 answer
Mysql datetime with timezone offset
SQL
22 votes286 views4 answers
Tsql rename table
SQL
5 votes163 views1 answer
Oracle scan source ddl
SQL