stable release of PG Lightning Admin for PostgreSQL 8.x.
PG Lightning Admin is a Windows GUI (graphical user interface)
administration program which will run on Windows 95,98, ME,NT 4SP6, 2000 and XP.
A full 30 day demo may be downloaded from:
http://www.amsoftwaredesign.com/downloads.php
Cost for the registered version is a low $29.99 (US Dollar).
For more information and screenshots please see:
http://www.amsoftwaredesign.com/lightning_admin.p
Features:
IDE style editors for functions,queries and views.
MDI style Interface which works similar to a word processor.
The Editors feature full code completion, Parameter Hints, and full syntax highlighting.
The Editors have full drag and drop editing, and will accept drag and drops from the databases schema tree view.
Tabbed based Enterprise Manager, each database and it’s schema is opened in it’s own tab.
Built in SSH tunnel capability.
Filtering MDI task bar. When a database is selected/opened, the MDI task bar only
shows open objects associated with that particular tab, which makes it easy to keep track of where
open objects belong.
Full backup and restore capabilities. A backup or restore is just a right-click away.
Query Editor is threaded and allows long running queries to be cancelled.
GUI Query Builder, accessed from the Query Editor’s menu bar.
Query Editor keeps a log/history of executed SQL queries
Query Editor saves it’s contents and restores the next time you open the editor.
Query Editor has a temp table watch window, which allows for easy debugging.
Full printing of DDL/Metadata and results sets.
Print preview allows the displayed data to be printed or exported as PDF, Word, Excel etc.
All Data grids are sortable and show a sort arrow in the column header.
All Data grids have a form view, which really helps when viewing large records.
All Data grids have full export capabilites such as comma/custom seperated, tabbed or fixed width.
The query data grid allows the result set to be filtered.
Quick View table view which will bring the the Top rows of a table or all rows.
Full featured grid based grant manager that supports the with grant option.
Server status monitor that allows queries running through the backend to be captured (command string must be enabled).
Environment options allow many features to be customized by the user.
Plus much more…”
