Have you used pgAdmin? It certainly does everything but it's user interface is too horrific for any simple tasks (like viewing rows or filtering by column etc.)

I wouldn't recommend it if I haven't used it.

Sure, the UI is ugly and it blocks on DB ops, but it works. Crashes I haven't had much of tbh

This sort of thing is really easy to do from a psql console; I don't think that should be a major point against pgadmin.

PGadmin also crashes often, and blocks on many database operations (eg modifying schema, adding indexes etc). How you can write a database GUI and make such a basic mistake as doing DB operations on the UI thread is beyond me.

It's a common mistake. Oracle's SQLDeveloper app does the same thing.