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 vote142 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
4 votes100 views1 answer
And or sql order of operations
SQL
5 votes166 views2 answers
Oracle list columns
SQL
0 vote146 views1 answer
Sql server user permissions and roles
SQL
0 vote156 views2 answers
How to get the date from datetime in mysql
SQL
0 vote135 views2 answers
Sqlite
SQL
11 votes133 views2 answers
Insert date sql
SQL
1 vote233 views1 answer
Mysql breakline on string
SQL
2 votes151 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote150 views2 answers
Change database postgres
SQL