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

2 votes134 views2 answers
Run mysql command from bash
SQL
0 vote131 views1 answer
Mysql_error replacement
SQL
0 vote148 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
3 votes137 views1 answer
Get current month last date in sql server
SQL
4 votes176 views2 answers
Mysql alter table set column unique
SQL
2 votes148 views1 answer
Query to find table size in oracle 12c
SQL
0 vote132 views1 answer
MySql get primary keys of table
SQL
2 votes131 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
7 votes259 views2 answers
Drop index oracle
SQL
6 votes132 views2 answers
Mysql get yesterday
SQL