I've been a long-time Navicat user, but it has a lot of trouble with any Postgres-specific features. I kind of recommend Postico, even in its incomplete state, for wrangling Postgres.