I absolutely love Postgres, for these and other reasons, but the one weak point is the official GUI client. It's garbage, and unfortunately it's one of the first things people ask me about when I encourage them to use Postgres.
The CLI is really really good for a CLI. Wagon is also good, my coworkers have been using it to pull data and like it a lot.
Overall love postgres, it's been 6 months (since starting a new job) and I'll never go back.
I have also paid for Postico (before they launched on the Mac App Store). As far as Postgres clients go, it is the best.
Edit: When evaluating Postgres GUI clients, make sure they support the new JSON and JSONB data types.