pgXplorer

pgXplorer is a freely downloadable, ISC licensed administration client for PostgreSQL versions 8.4 and above.

Key features are per-database instance, multithreaded queries, an intuitive UI and an SQL console/editor that supports syntax highlighting and more.