I'm pretty happy at the moment editing in vim invoked from psql with \e - which has been my setup for way more than a decade now, but I do miss isql (Query Analyzer) from SQL Server 2000, which was just about perfect.
Postgres.app is server-only, no?