pgEdit free download, pgEdit download on software download

pgEdit is a top performance SQL editor and development environment specifically designed for PostgreSQL databases. pgEdit is based on the powerful programmable editor included in LispWorks. The complete documentation for the LispWorks editor (“Editor User Guide”) can be found online at Lispworks documentation page (this can be helpful as a detailed reference, but not all commands and functions are available in pgEdit). The editor is based on Emacs and shares much of the same design and terminology. A buffer is a temporary storage area where editing operations take place. A new empty buffer is created each time a new pgEdit window is created. A buffer may have an associated file where the buffer contents are stored when the save command is executed. In the traditional Emacs model a buffer can be associated with more than one window, but pgEdit keeps a one-to-one correspondence between buffers and windows. See the Select Window command for a quick way to select among all active windows. A point is a location within the buffer where editing operations take place. The current point is a special point that corresponds to the cursor or insertion point. A mark is simply a saved point in the buffer. Marks can be used to jump to specific saved locations in the buffer. More commonly, a region is created between the current point and the mark. A region is simply an area of selected text to which editing operations can be applied. The easiest way to create a region is no different from any other text editor: just drag with the mouse button down over the desired text. Each buffer operates in one primary major mode. A mode is a collection of key sequences and commands for operating on a particular kind of text. By default, a new window in pgEdit uses SQL mode. This mode is invoked automatically when a file is opened with a .sql or .pgsql extension. In SQL mode, SQL and PL/pgSQL syntax coloring is activated and special key bindings are available for executing SQL. pgEdit also supports Text mode for editing plain text files. Output is the mode used for buffers used to collect the output from SQL execution. Each buffer can also support zero or more minor modes. Minor modes further customize the behavior of the major mode. Main features: 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 the entire buffer, the highlighted region, the current SQL line containing the cursor, or 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. 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.

pgEdit Related Software