Search code examples
postgresqltransactionscommitrdbmsrollback

Not using "begin transaction" and "commit" statements in Postgresql

Whenever I am accessing a PostgreSQL database with terminal I don't use "begin transaction" or "commit;" statements. Still, changes made by me on the database are permanent. (they don't get rollbacked when I turn off terminal). Why is it? Is there anything am I missing?

Solution

  • By default psql CLI interface runs in autocommit mode. See https://dzone.com/articles/autocommit-in-postgresqls-psql