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

3 votes434 views1 answer
Apex call duration
SQL
0 vote373 views1 answer
Sql last time database was accessed
SQL
0 vote383 views1 answer
Psql initialization
SQL
0 vote353 views1 answer
Database get 10 user aleatory
SQL
0 vote352 views1 answer
Zerar auto increment mysql
SQL
0 vote410 views1 answer
Postgres docs /copy metacomand
SQL
0 vote383 views1 answer
Alter table change default
SQL
1 vote363 views1 answer
Mysql how to truncate table with foreign keys
SQL
5 votes363 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote359 views1 answer
Hive batch drop table
SQL