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

28 votes195 views4 answers
Mysql delete database
SQL
7 votes200 views2 answers
Create mysql user
SQL
2 votes204 views1 answer
Oracle drop sequence if exists
SQL
4 votes192 views4 answers
Rollback in sql
SQL
2 votes237 views2 answers
Sql query to copy data from one column to another
SQL
1 vote208 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
0 vote281 views1 answer
Linux upload database to mysql
SQL
1 vote191 views1 answer
Mariadb case switch
SQL
0 vote222 views1 answer
Sql get latest of 2 datetimes
SQL
0 vote200 views1 answer
Set engine to innodb
SQL