EMS SQL Query forPostgreSQL

What is EMS SQL Query forPostgreSQL?

EMS SQL Query for PostgreSQL is a useful tool that allows you to create SQL queries quickly and simply in PostgreSQL databases. Visual PostgreSQL queries creation and direct editing of query text are available. The user-friendly graphical interface allows you to connect to PostgreSQL databases, select tables and fields for a query to the PostgreSQL server, define selection criteria, and more. Using this query utility, you can work with multiple PostgreSQL queries at once, edit the query text in the powerful SQL editor, view the execution results in different modes, create PostgreSQL queries with joints and subqueries visually, create queries-based diagrams, view the postgreSQL query execution plan, and perform any other operations you might need in your work with queries to the PostgreSQL database.

Core features

• Friendly graphical interface.
• Full support of the PostgreSQL server up to version 9.0.
• UTF8 media.
• Connect through the SSH tunnel: Connect to an intermediate SSH server and route all PostgreSQL commands through the secure tunnel.
• Connect through the HTTP tunnel in case of Internet access only by the HTTP proxy or if the server does not allow direct connections to PostgreSQL.
• Using drag-and-drop operations when visually selecting tables and fields for a query.
• Working simultaneously with multiple queries in separate windows.
• Registering databases to work only with the required databases.
• Multiple connections to the database.
• Navigation in newly used queries and selection of the necessary queries.
• Syntax highlight, "fast code" and keyboard templates for faster editing of query text.
• Tools for grouping and filtering data.
• The ability to create queries with joints and subqueries visually.
• The ability to create diagrams based on queries.
• Resources for viewing query plans.
• Powerful BLOB viewer/editor with various types of BLOB data visualization.
• Flexible customization of the graphical user interface.
• Multilingual GUI (Graphical User Interface) support.

System requirements

300 MHz processor; Recommended 600 MHz (MHz) processor

Microsoft® Windows NT4 com SP4 ou posterior, Microsoft® Windows 2000, Microsoft® Windows 2000 Server, Microsoft® Windows XP, Microsoft® Windows 2003 Server, Microsoft Windows 2008 Server, Microsoft® Windows Vista, Microsoft® Windows 7.

64 MB of RAM or more; 128 MB or more recommended

20 MB 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 is recommended

Microsoft mouse® or compatible pointing device

Possibility to connect to any local or remote PostgreSQL server