Postgresql transaction

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 vote178 views1 answer
Resulting Query
SQL
7 votes195 views2 answers
Get database size mysql
SQL
9 votes184 views2 answers
Nosql databases
SQL
0 vote210 views1 answer
Connect to ssms with python
SQL
0 vote217 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
1 vote187 views2 answers
String to date postgres
SQL
1 vote205 views2 answers
Mysql error 1215
SQL
2 votes198 views1 answer
Get hour from date sql
SQL
9 votes198 views4 answers
Mysql show table fields
SQL
0 vote185 views1 answer
Phpmyadmin tabellentyp ändern
SQL