pgEdit is a high performance SQL editor and development environment for PostgreSQL. pgEdit features include SQL syntax coloring, direct source code execution, PHP support, integrated documentation, and extensive customizable editing facilities. PostgreSQL (http://www.postgresql.org/) is the world's most advanced open source database and is freely available for all major operating systems including Macintosh, Windows, Linux, and Unix.

PG Lightning Admin is a powerful GUI administration program for Postgresql 7.4.x and greater.
It includes many advanced features such as a tabbed based MDI system, tabbed Enterprise Manager and more.
Other features include a advanced function editor, SQL edtior and view editor.
All the editors also code completion and function param hints.