EMS SQL Query for PostgreSQL 3.2

1. User-friendly graphical interface
2. Full support of PostgreSQL server up to version 8.2.x
3. Support of UTF8 data
4. Connect through SSH tunnel: establish connection to an intermediate SSH server and forward all PostgreSQL commands through the secure tunnel
5. Connect through HTTP tunnel in case of Internet access through HTTP proxy only, or if the server does not allow direct connections to PostgreSQL
6. Using drag-and-drop operations when selecting tables and fields for a query visually
7. Working simultaneously with several queries in separate windows
8. Registering databases for working with the required databases only
9. Multiple database connections
10. Navigation within recently used queries and selecting the required queries
11. Syntax highlight, "quick code" and keyboard templates for faster editing query text
12. Tools for data grouping and filtering
13. The ability to create queries with unions and subqueries visually
14. The ability to create diagrams based on queries
15. Capabilities for viewing query plans
16. Powerful BLOB viewer/editor with several types of viewing BLOB data
17. Flexible personalization of graphical user interface
18. Multi-language GUI support

Enhancements:

• Unicode data support is implemented (InterBase/Firebird, DB2).
• The Favourites tab is added to ensure fast access to Favorite Queries.
• The Optimize Goal option is added (Oracle).
• The utility now requests re-connection when the connection to a database is lost (InterBase).
• Added the “Show default schema” option which allows you to avoid specifying objects names when it is not necessary (SQL Server, Oracle, PostgreSQL, DB2).
•  Visual building of the FROM statement subqueries is now possible.
• User-defined aggregate functions are now available in the Aggregate drop-down list in Query Builder (PostgreSQL, SQL Server).
• Some other small bugfixes and improvements.

Requirements:

• 300-megahertz (MHz) Pentium II-compatible or faster processor; 600--megahertz (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
• 20MB of available HD space for program installation
• Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution video adapter and monitor recommended
• Microsoft Mouse or compatible pointing device
• Possibility to connect to any local or remote PostgreSQL server