I've been holding out on upgrading my Postgres installation because I don't want to use the new pgAdmin viewer. What are some of the other alternatives that people like?
I like psql, the terminal-based frontend that ships with PostgreSQL. It's quite powerful.
I've written an extensive guide on how to use it, which I hope convinces you of its power.