EMS SQL Query for PostgreSQL

Overview

EMS SQL Query for PostgreSQL is a useful tool that lets you quickly and simply build SQL queries to PostgreSQL databases. Visual PostgreSQL query building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to PostgreSQL databases, select tables and fields for a query to PostgreSQL server, set the selection criteria and much more. Using this query utility you can work with several PostgreSQL queries at once, edit query text in the powerful SQL editor, view the execution results in different modes, create PostgreSQL queries with unions and subqueries visually, build diagrams based on queries, view PostgreSQL query execution plans and perform any other operations you may need in your work with PostgreSQL database queries.

Key Features

User-friendly graphical interface

Full support of PostgreSQL server up to version 9.0

Support of UTF8 data

Connect through SSH tunnel: establish connection to an intermediate SSH server and forward all PostgreSQL commands through the secure tunnel

Connect through HTTP tunnel in case of Internet access through HTTP proxy only, or if the server does not allow direct connections to PostgreSQL

Using drag-and-drop operations when selecting tables and fields for a query visually

Working simultaneously with several queries in separate windows

Registering databases for working with the required databases only

Multiple database connections

Navigation within recently used queries and selecting the required queries