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

14 votes104 views2 answers
Sql cast
SQL
20 votes115 views5 answers
Reset auto increment mysql
SQL
0 vote94 views1 answer
Month mysql
SQL
0 vote108 views1 answer
Power query datetime to date
SQL
0 vote61 views2 answers
Jupyter notebook connect to database
SQL
0 vote101 views1 answer
Psql initialization
SQL
0 vote103 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote108 views1 answer
How to find lowest in sql
SQL
4 votes98 views1 answer
Oracle show errors compilation
SQL
0 vote101 views1 answer
How to find sql server installation folder
SQL