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

4 votes205 views2 answers
Linq join
SQL
0 vote213 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote157 views1 answer
Sql new line output
SQL
0 vote211 views1 answer
Postgresql create query
SQL
0 vote210 views1 answer
Postgresql combine values in one field
SQL
0 vote193 views1 answer
How to install sql in anaconda
SQL
0 vote182 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote209 views1 answer
Sql if clause within where clause
SQL
0 vote189 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote182 views1 answer
Restore backup "text" postgresql command line
SQL