Thread: How to rollback a sql

How to rollback a sql

From
"Alex Cheung Tin Ka"
Date:
Dear All,
    I would like to know how to make the pgsql system not doing the auto commit and let me have time to do the roll back.
 
Regards,
 
Alex Cheung Tin Ka

Re: How to rollback a sql

From
Jeff Davis
Date:
>     I would like to know how to make the pgsql system not doing the auto
> commit and let me have time to do the roll back.

Just start by executing the query "BEGIN" and then it won't commit until you
execute the query "COMMIT".

ex:
=> BEGIN;
=> [ more queries here]
=> COMMIT;

or
=> BEGIN;
=> [more queries]
=> ROLLBACK;

Regards,
    Jeff