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 votes172 views1 answer
Oracle drop table free up space
SQL
0 vote172 views1 answer
Sql contains vs like
SQL
0 vote135 views1 answer
Oracle function select into
SQL
0 vote181 views2 answers
Sql max count
SQL
0 vote194 views1 answer
Create table split string function in sql server
SQL
4 votes177 views1 answer
Refresh postgres config
SQL
0 vote166 views1 answer
Sql server cannot create database diagram
SQL
0 vote197 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
0 vote176 views1 answer
Sql find gaps in date ranges
SQL
0 vote175 views1 answer
Mariadb select limit offset
SQL