I was really excited when Induction (http://inductionapp.com/) was announced, but I don't think there's too much development for it. The interface is probably the best I've seen, but functionality is fairly sparse. pgAdmin3 has been my go-to app, but I'm excited try out PostgreSQL Studio!