I also abandoned pgAdmin because of flaky connection handling, as well as several annoying bugs on the Mac version. I was happy with psql for a while (and still

I also abandoned pgAdmin because of flaky connection handling, as well as several annoying bugs on the Mac version. I was happy with psql for a while (and still sometimes use it), but IntelliJ's DB plugin is by far my favorite now. Its autocomplete is really smart, which makes a big difference in writing queries without having to constantly check various table definitions.