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
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 file.
* 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.
* 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.
* Integrated documentation
Help in pgEdit is provided with context sensitive links to the online documentation displayed in your preferred web browser. The PostgreSQL documentation is also included with direct links to important sections provided in the pgEdit Help menu. The documentation for the SQL command nearest to the cursor can be retrieved by pressing a user configurable key sequence.
* Cross platform and easy to install
pgEdit is a native application for both Macintosh and Windows. It does not use Java or require installation of external libraries. You have the option of using the version of psql included with pgEdit or a different version installed anywhere on your hard drive.
For more information, please visit http://pgedit.com/.
This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.