Sequel Pro is awesome... I think they are working toward offering Postgres support: http://code.google.com/p/sequel-pro/issues/detail?id=362 but haven't seen anything concrete yet.

I just learned SP has bundles, like TextMate. Nifty.