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 vote332 views1 answer
Mysql where in maintain order
SQL
2 votes321 views1 answer
Power query concatenate
SQL
10 votes329 views2 answers
Select nextval from sequence oracle
SQL
0 vote337 views1 answer
Cannot pip install mysqlclient
SQL
0 vote315 views1 answer
Add column in sql server ubuntu
SQL
2 votes335 views2 answers
Calculate percentage in sql
SQL
0 vote304 views1 answer
Enable Rabbitmq management plugin
SQL
5 votes299 views2 answers
Oracle tables with column name
SQL
1 vote312 views1 answer
Import sql file mysql commadn line
SQL
0 vote337 views3 answers
Run sql command line
SQL