[skyebook]

pgAdmin III, it does damn near everything you could need. http://www.pgadmin.org

[obsession]

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.)

[skyebook]

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

[NathanRice]

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.

[jordanthoms]

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.

[jacques_chester]

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