postgresqlHow do I use a PostgreSQL transaction?
A PostgreSQL transaction is a sequence of SQL statements that will either all succeed or all fail.
To use a PostgreSQL transaction, you must first begin the transaction with the BEGIN command.
BEGIN;Then, you can execute any number of SQL statements that you desire. For example:
INSERT INTO table1 (col1, col2) VALUES (val1, val2);
UPDATE table2 SET col3 = val3 WHERE col4 = val4;Once all the desired statements have been executed, you must either commit the transaction with the COMMIT command or rollback the transaction with the ROLLBACK command.
COMMIT;If the COMMIT command is executed, all the statements within the transaction will be executed. If the ROLLBACK command is executed, none of the statements within the transaction will be executed.
Helpful links
More of Postgresql
- How can I use PostgreSQL and ZFS snapshots together?
- How do I install and configure PostgreSQL on a Windows machine?
- How do I use PostgreSQL ZonedDateTime to store date and time information?
- How can I extract the year from a PostgreSQL timestamp?
- How can I use PostgreSQL with YAML?
- How can I use PostgreSQL for my project?
- How do I use PostgreSQL's XMIN and XMAX features?
- How do I use PostgreSQL and ZFS together?
- How do I parse XML data using PostgreSQL?
- How do I use a PostgreSQL XML parser in an example?
See more codes...