I use Intellij Idea with Database plugin and it works perfectly. SQL syntax highlighting (for PostgreSQL dialect), autocomplete (using actual table definitions from the database), visual table editor. I can run SQL query, edit some cell in the result table and that edit will update the database.
There's a dedicated cheaper product called 0xDBE if you don't own Idea and don't need Java support.
Postico looks nice and I like the fact that it's a native app. But without highlighting and autocomplete it's not very interesting for me, I'm SQL guy.
I've solely used the command line client for the last few years. I stopped using pgAdmin because it did not gracefully handle flakey network connections (i.e. vpn restarts). Has this improved recently?
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.
This has not improved. However, instead of using screen in a terminal to do a long create table query, I'll now just kick it off in pgAdmin and yank my ethernet. This causes the query to just hang out there indefinitely until it's done. Stupid, yes. But it's kinda fun.
For the web, TeamPostgreSQL[1] does most of these, like SQL autocomplete including schema object names, live editing query results, table editing, etc. It also has click-through foreign key references, look up rows that reference this one, and other smart features.
I use the PyCharm plugin. It doesn't look like much to start with but now i've used it a bit it's actually one of the best DB clients i've ever used, especially for editing SQL queries thanks to great sytnax highlighting and completions.
Yep, any varient of jetbrains with their awesome sql +++ support beats this and most others hands down. Especially if you're someone who'd actually use this for real work. Like a statistician/analyst
There's a dedicated cheaper product called 0xDBE if you don't own Idea and don't need Java support.
Postico looks nice and I like the fact that it's a native app. But without highlighting and autocomplete it's not very interesting for me, I'm SQL guy.