pgEdit is a high performance SQL editor and development environment .
EditBy: pgEdit is a high performance SQL editor and development environment designed specifically for PostgreSQL relational databases. pgEdit features include:

SQL Syntax coloring optimized for PostgreSQL
PostgreSQL represents function bodies as single quoted strings which most editors render with a single color. pgEdit promotes better usability and correctness by using SQL syntax coloring within the body of function strings. Keyword coloring is based directly on the source code of PostgreSQL.

SQL source code Execution without saving files or switching applications
SQL source code execution without saving the file or switching applications
pgEdit pgEdit can execute the SQL source code for (1) the entire buffer, (2) the highlighted region, (3) the current SQL line containing the cursor, or (4) the current SQL line to the end of the file buffer. pgEdit also supports command-line style execution of SQL where there is no need to include the source code in an editor document.

Direct integration with psql, the PostgreSQL interactive terminal
In addition to SQL, almost all psql commands are supported. This provides a powerful facility for examining, designing, and managing databases.

Fast, Grid-based query browser
Result sets of any size are efficiently handled using automatic cursor management (no use of COUNT(*) or LIMIT/ORDER BY to manage paging). Columns are automatically sized and aligned to fit the result set. Execute one SQL line at a time simply by putting the cursor anywhere on the line and pressing a user configurable key stroke. This makes it fast and easy to work interactively just by typing a series of SQL commands in the buffer. No special History mechanism is needed -- simply MOVE the cursor to any line and execute it.

PHP integration
PHP can act as a preprocessor for SQL code or perform other scripting tasks. Mixed syntax coloring of PHP and SQL in the same file is supported including syntax coloring for pl/PHP stored procedures. you can free download PgEdit 1.4.1 now.