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

5 votes202 views3 answers
Truncate function in sql oracle
SQL
0 vote231 views1 answer
Unique element in sql
SQL
10 votes214 views3 answers
How to fetch first 5 characters in sql
SQL
1 vote210 views1 answer
Oracle enable job
SQL
2 votes210 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote213 views1 answer
Copy data from one postgres container to another
SQL
0 vote261 views1 answer
ORACLE PARSE STRING
SQL
12 votes237 views6 answers
Distinct in sql server
SQL
0 vote295 views1 answer
Mysql get nested records
SQL
0 vote241 views1 answer
Como hacer un select entre fechas mysql
SQL