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 vote120 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote131 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote132 views1 answer
Sql track modification
SQL
0 vote162 views1 answer
Postgres foreign key multiple columns
SQL
31 votes121 views1 answer
Postgresql add column with constraint
SQL
0 vote156 views1 answer
C# sql transaction multiple connections
SQL
4 votes126 views1 answer
Oracle select first 10 rows
SQL
14 votes122 views3 answers
Trim sql
SQL
20 votes140 views3 answers
How to open postgresql in mac
SQL
0 vote110 views1 answer
Sub blocks in sql
SQL