Postico is a modern Postgres client for OS X — written by Jakob Egger, who also happens to be the maintainer of Postgres.app.
Postico features a beautiful interface for creating tables and working with data. For complex queries it also includes a powerful SQL editor.
To connect with Postgres.app, there's no configuration necessary. Just click "Connect".