Sequel Pro 1.0 released
sequelpro.com
sequelpro.com
...which I couldn't use because I'm on 10.6. the website is colorful though so there's that.
I ended up using this...
which is browser based but does the job
It also appears to be abandonware.
PgAdmin III is currently the best (free) GUI for postgres. It's not without its own issues (mostly with missing keybindings and focus issues) and it's ugly but it is at least functional.
Basically the best hope is for the Sequel Pro guys to support PostgreSQL, which they have stated they intend to do.
http://www.navicat.com/en/products/navicat_premium/premium_d...
Just pg: http://www.navicat.com/en/products/navicat_pgsql/pgsql_detai...
Unfortunately, SequelPro's support for more advanced (if once can call it like that) features like views, stored procedures, triggers is not so great.
If only I had a working knowledge of Obj-C, I'd try and lend a had to those guys :/
Edit: To reiterate, this is just a wonderful project. They hadn't updated since 2011 and yet I've been using Sequel Pro daily, on Mountain Lion, with nary a hitch. I'm not a MySQL power user by any means so having this reliable, free tool to make handling gigabyte datasets a breeze is just a real boon to daily productivity and anti-frustration.
There are many great free GUI apps out there, of course (every major web browser, major web app, OpenRefine, etc)., but MySQL on a Mac seems like such a niche market that I assume no one would put real resources or talent to creating a slick GUI for it. Discovering Sequel Pro a few years back has been one of my favorite open source experiences in awhile.
Why use this instead of MySQL Workbench? Genuinely curious.