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 vote322 views1 answer
In query in sql
SQL
5 votes317 views1 answer
Get table columns from sql
SQL
-1 vote312 views1 answer
Mysql select count if contains
SQL
1 vote317 views3 answers
Showing all columns in an sqlite table
SQL
0 vote321 views1 answer
Sql common columns
SQL
0 vote282 views1 answer
Mysql workbench search all tables
SQL
3 votes314 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote506 views1 answer
The differnece between to values in sql
SQL
0 vote300 views1 answer
Postgresql where clause not working
SQL
0 vote328 views1 answer
Shows all databases created by user in ms sql
SQL