EMS SQL Manager for PostgreSQL is a high performance tool for PostgreSQL Database Server administration and development. SQL Manager for PostgreSQL works with any PostgreSQL versions up to 8.3 and supports the latest PostgreSQL features including enumerated, text search, XML and UUID data types, index key sorting order, arrays of composite types, and others. It offers plenty of powerful tools for experienced users such as Visual Database Designer, Visual Query Builder, and powerful BLOB editor to satisfy all their needs. SQL Manager for PostgreSQL has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.
Support of UTF8 data
Excellent visual and text tools for query building
New state-of-the-art graphical user interface
Rapid database management and navigation
Advanced data manipulation tools
Full support of PostgreSQL up to version 8.3
Improved database explorer for easy management of all PostgreSQL objects
Effective security management
Impressive data export and import capabilities
Powerful visual database designer
Easy-to-use wizards performing PostgreSQL maintenance tasks
Connecting via local port forwarding through the SSH tunnel
Access to PostgreSQL Server through HTTP protocol
300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista
64 MB RAM or more; 128 MB or more recommended
50MB of available HD space for program installation
Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
Microsoft Mouse or compatible pointing device
Local or remote PostgreSQL Server version 7.1, 7.2, 7.3, 7.4, 8.0, 8.1, 8.2, EnterpriseDB 8.1, EnterpriseDB 8.2
What's new in SQL Manager for PostgreSQL 4.3?
Support of new PostgreSQL 8.3 features:
>>support of ENUM data types
>>support of TSVECTOR, TSQUERY, XML and UUID types;
>>support of arrays of composite types;
>>support of index key sorting order (ASC, DESC; NULLS FIRST, NULLS LAST);
>>support of new PostgreSQL 8.3 statistic data (Database Statistics tool).
Support of operator classes in index keys.
DB Explorer. Composite types are now displayed as a separate node within the database objects tree.
>>Unicode was not supported upon inputting parameters for queries containing parameters' declaration. Fixed now.
>>When working with several instances of SQL Editor, Favorite queries were not always saved correctly. Fixed now.
SQL Editor, SQL Script Editor.
>>A number of functions now work faster.
>>For some statements code folding worked incorrectly; also, in DDL functions code folding is now used to collapse the entire function body.
>>The code completion list for table aliases was not opened if used at the end of the query. Fixed now.
>>The first word of the statement is now displayed in the collapsed code parts.
>>Keyboard templates do not trigger in comments any more.
>>The default schemas from the search_path configuration parameter are considered when applying the code completion and object links highlight.
Import Data Wizard.
>>The client encoding was not considered, therefore the 'Invalid byte sequence for encoding...' error occurred in some cases. Fixed now.
>>The 'Commit changes manually' option did not work. Fixed now.
>>Sub-levels based on a SQL query can now be edited in the Load All Rows mode as well, if the query is built by one table and contains key fields.
>>Upon insertion of text into a grid cell, pressing Shift-Ins resulted in duplicating field dialog. Fixed now.
>>Depending on the program settings, if a column name contained the dot (.) character, it was impossible to edit table data. Fixed.
When deleting an index, the index name did not contain the schema name in the generated SQL statement. Fixed now.
Export Data Wizard. When exporting results of queries of a certain type, the 'Parser: parse error at end of input' error used to occur. Fixed now.
SQL Manager wizards. The databases configured for connection via SSH and HTTP were not displayed in database drop-down lists. Fixed now.
When working with PostgreSQL 8.3, all triggers were displayed as disabled. Fixed now.
Visual Options. The 'Menus show recently used commands first' option was not saved upon closing the application. Fixed now.
Function Editor. The Ctrl-Ins and Ctrl-Del shortcuts are added for adding and removing parameters respectively.
Create Database Wizard. At the Setting advanced database properties step only parameters that are applicable for the current server version are displayed now.
Keyboard Templates. When using the Paste command in a template body, applying the template resulted in insertion of the first word only, instead of the insertion of entire text from the clipboard. Fixed now.
Dependency Tree. If the tree building was interrupted, rebuilding was not initiated after subsequent selection of an object. Fixed now.
Other minor improvements and bug-fixes.