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 vote193 views1 answer
Generate sequence number in sql server
SQL
0 vote194 views1 answer
Oracle db get table sizes
SQL
2 votes202 views1 answer
Laravel sql String
SQL
0 vote219 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
4 votes242 views1 answer
Ms sql truncate table vs delete
SQL
0 vote222 views1 answer
PostgreSQL types and C# types
SQL
3 votes201 views3 answers
List columns in table postgres
SQL
0 vote262 views1 answer
What is metadata in sql
SQL
26 votes196 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote261 views1 answer
Reindexing all tables sql server
SQL