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.
* SQL source code execution without saving files or switching applications
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.
* 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.
* 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.
* Extensive and customizable editing facilities
pgEdit is a full featured text editor with hundreds of commands available. A friendly interface is included to provide online documentation and customize the key bindings for any command. Menu shortcuts can also be customized. pgEdit supports traditional Macintosh and Windows editing features, as well as Emacs-style key bindings.
* Cross platform and easy to install
pgEdit is a native application for both Windows and Macintosh (Universal Binary). It does not use Java or require installation of external libraries.