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

1 vote115 views1 answer
Loading local data is disabled mysql
SQL
0 vote114 views1 answer
Object Information
SQL
1 vote178 views2 answers
Sql server find all foreign keys that reference a column
SQL
2 votes84 views1 answer
Latest record in sql
SQL
0 vote124 views2 answers
How to update the multiple rows in sql
SQL
0 vote134 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote112 views1 answer
Sql last 7 days
SQL
0 vote122 views4 answers
Change schema in sql server
SQL
0 vote125 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
20 votes126 views5 answers
Reset auto increment mysql
SQL