EMS SQL Manager for PostgreSQL Freeware 4.3

EMS SQL Manager for PostgreSQL Freeware 4.3 is specially designed as a program for PostgreSQL Database Server administration and development. PostgreSQL Manager works with any PostgreSQL versions up to 8.2 and supports all of the latest PostgreSQL features including tablespaces, argument names in functions, and so on. 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. PostgreSQL Manager 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.

Major Benefits:

1. FREE One Year of Maintenance already included!
2. FREE software updates and upgrades during Maintenance period!
3. FREE and unlimited Technical Support during Maintenance period!
4. Reasonable pricing for Maintenance renewal – from 20% per Year!
5. Volume discounts when buying two or more copies of one product
6. Cross-selling discounts on related products

Major  Features:

1. Support of UTF8 data
2. Excellent visual and text tools for query building
3. New state-of-the-art graphical user interface
4. Rapid database management and navigation
5. Advanced data manipulation tools
6. Full support of PostgreSQL up to version 8.3
7. Improved database explorer for easy management of all PostgreSQL objects
8. Effective security management
9. Impressive data export and import capabilities
10. Powerful visual database designer
11. Easy-to-use wizards performing PostgreSQL maintenance tasks
12. Connecting via local port forwarding through the SSH tunnel
13. Access to PostgreSQL Server through HTTP protocol

Enhancements:

1. 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).
2. Support of operator classes in index keys.
   
3. DB Explorer. Composite types are now displayed as a separate node within the database objects treeSQL Editor.
   
   • 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.
4. 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.
5. 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.
   • Data grid.
6. • 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.
7. When working with PostgreSQL 8.3, all triggers were displayed as disabled. Fixed now.
   
8. Visual Options. The 'Menus show recently used commands first' option was not saved upon closing the application. Fixed now.
   
9. Function Editor. The Ctrl-Ins and Ctrl-Del shortcuts are added for adding and removing parameters respectively.
   
10. Create Database Wizard. At the Setting advanced database properties step only parameters that are applicable for the current server version are displayed now.
    
11. 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.
    
12. Dependency Tree. If the tree building was interrupted, rebuilding was not initiated after subsequent selection of an object. Fixed now.
    
13. Other minor improvements and bug-fixes

Requirements:

• 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, Enterprise DB 8.1, EnterpriseDB 8.2

WareSeeker Editor