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

15 votes267 views2 answers
Open postgress in terminal mac
SQL
4 votes272 views2 answers
SELECT table_name FROM user_tables;
SQL
9 votes284 views1 answer
No sql
SQL
1 vote271 views1 answer
Oracle check table space
SQL
0 vote307 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote267 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote277 views1 answer
VSCode SQL Server Connection error
SQL
0 vote312 views1 answer
Fetching data from mysqldb
SQL
1 vote285 views1 answer
How to lock table in mysql
SQL
7 votes299 views2 answers
Phpmyadmin change password
SQL