SequelPro is incredible - easy to use, beautiful, reliable, powerful - but it only works with MySQL (or MariaDB). I've tried Toad but it's very buggy and ugly. The AppStore has SQLPro for Postgres, but I've not heard any reviews, so I'm reticent to spend $30. I've used a Navicat trial for MySQL and it was good but costs around $200.
And actually content copied as well to make it easier to digest:
If you're looking for a list of other clients some of the others ones include:
- Postico OSX - https://itunes.apple.com/us/app/postico/id1031280567?ls=1&mt...
- JackDB (web based) - https://www.jackdb.com/
- SQL Pro for Postgres - http://www.hankinsoft.com/SQLProPostgres/
- PGAdmin - Slightly outdated but still feature rich and fully cross platform - http://www.pgadmin.org/
And of course there's always psql which is all CLI, but incredibly flexible.
I've tried to compile a list of OS X Postgres clients in the docs for Postgres.app: http://postgresapp.com/documentation/gui-tools.html
If you know of any other, let me know.
There's also the list of GUI tools in the wiki: https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS...