If you use postgres you can put \set AUTOCOMMIT off In your .psqlrc and then you can never forget the begin transaction; every statement is already in a tra

If you use postgres you can put \set AUTOCOMMIT off In your .psqlrc and then you can never forget the begin transaction; every statement is already in a transaction, its just the default behaviour to automatically commit the statements for some ungodly reason. Years ago I hired an experienced Oracle developer and put him to work right away on a SQL Server project. Oracle doesn't autocommit by default, and SQL Server does. You don't want to learn this when you type "rollback;". I took responsibility and we had all the data in an audit table and recovered quickly. I wonder if there are still people who call him "Rollback" though.