DataGrip has transaction control in the tool menu. It is pretty handy to have that toggle at hand.
Yes, I know how to write a manual transaction, but the point of using a GUI tool is to speed things up and make my life as a Data Engineer easier. It is not for forcing me to type extraneous commands repeatedly.
Porch
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Monday, October 16, 2017 at 11:30 AM
To: Melvin Davidson <melvin6925@yahoo.com>
Cc: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>, legrand legrand <legrand_legrand@hotmail.com>
Subject: Re: No commit nor Rollback button
and change Auto commit? to False
and Auto rollback? to False
That is what those options are for!
Or learn how to use a TRANSACTION in PostgreSQL.
Personally, if I'm in a GUI I'd prefer buttons. They both allow one to quickly see whether they are in a transaction or not (by greying out the buttons when their use is not applicable) and provide a mouse user a very quick way to commit/rollback the query they just executed via clicking the "run query" button.
This has absolutely nothing to do with "Auto Commit/Rollback" other than the buttons would only be meaningful when said option is disabled.