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 vote275 views1 answer
Creation d'un trigger sql
SQL
1 vote297 views1 answer
Pl sql create table from another table
SQL
3 votes282 views2 answers
Sql select data from last week
SQL
0 vote283 views1 answer
Mysql check if lowercase
SQL
2 votes266 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
1 vote308 views1 answer
Set id count mysql
SQL
4 votes275 views2 answers
Sql table
SQL
4 votes332 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
1 vote272 views1 answer
Mysql select update same table
SQL
3 votes296 views1 answer
Increment integer in table sql
SQL