psql is good but how do you manage long multi line queries and saved collections of queries to reuse? or connections to multiple databases?
I keep queries in .sql files in git repo. I run longer queries by writing them in a file and including/running it with \i. There's also \e to open $PSQL_EDITOR.
I spend a lot of time there though so I can see the appeal of a gui for someone who only occasionally looks around in the db.