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 vote337 views1 answer
Mysql stop password policy
SQL
0 vote359 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote347 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
37 votes537 views3 answers
Sql check duplicate value in column
SQL
2 votes338 views2 answers
How to view created temporary tables in mysql
SQL
0 vote339 views1 answer
Datagrip exec
SQL
0 vote358 views5 answers
How to make trigger in phpmyadmin
SQL
1 vote379 views1 answer
Psql filed name alter
SQL
0 vote358 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote326 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL