EMS SQL Manager 2005 for PostgreSQL

Powerful graphical tool for PostgreSQL DB Server administration and development EMS SQL Manager for PostgreSQL is a powerful tool 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 many others.

EMS SQL Manager for PostgreSQL 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.

Here are some key features of "EMS SQL Manager 2005 for PostgreSQL":
Full support of PostgreSQL up to version 8.2

Support of FILLFACTOR parameter for tables and indices

Creating indexes concurrently

Creating domains based on other domains

Support of CONNECT permission for databases and USAGE permission for sequences

Changing column types

Support of argument names in functions

Support of dollar-quoted strings

Support of UTF8 data

New state-of-the-art graphical user interface

Office 11 and Windows XP visual schemes support

New well-described Wizard System

Improved database explorer for easy management of all PostgreSQL objects

New Windows Toolbar to switch between windows easily, like in Windows Task Bar

Navigation bars with hot actions in most of the windows

Ability to save all program settings

Customizable toolbars for all program windows

Fully customizable program interface

Powerful visual options module

Localizable program interface

Rapid database management and navigation

Multiple host/database connections

SSL connections support

Registering selected databases to work with

Projects to work with the selected database objects only

Access to PostgreSQL Server through HTTP protocol

Connecting via local port forwarding through the SSH tunnel

Multiple user-defined tabs for any tree node to access it in one-click

Working with multiple selected objects at a time

Grouping/Ungrouping registered databases by host name

Easy management of all PostgreSQL objects

Creating/dropping databases and schemas

Managing tables and all their subobjects: fields, indices, triggers, rules, checks and foreign keys

Managing views, functions, sequences

Managing types, aggregates, operators, languages

Managing table/view rules

Duplicating all database objects

Renaming all database objects

Powerful PL/pgSQL function debugger

Viewing dependencies between database objects

Advanced data manipulation tools

Powerful BLOB viewer/editor with several types of viewing BLOB data

Plenty of useful tools such as data grouping, fast searching and filtering

Master-detail view to work with two linked tables at the same time

Table and card views to see data the way you like

Ability to copy and paste selected records

Ability to create diagrams based on queries

Exporting data to SQL script as INSERT statement

Effective security management

Powerful user and group manager for administering users and privileges

Grant manager displaying all database object grants in the form of a grid

Viewing and changing object permissions to database roles in object editors

Excellent visual and text tools for query building

Visual query builder allowing you to build complicated queries without any knowledge of SQL syntax

Multiple SQL editors with code completion, syntax highlight and code folding

Large script execution (SQL script editor)

Ability to view query plan as diagram

SQL Formatter (Available from SQL Editor context menu)

Favorite Queries (Save and use your frequently used queries easily)

Report designer with clear in use report construction wizard

New Create Report Wizard allows you to create simple reports in a few clicks

Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree

Impressive data export and import capabilities

Exporting data to most popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF etc

Importing data from MS Excel, MS Access, DBF, XML, ODF, TXT and CSV

Wizards for copying data from/to file on server

Copying metadata and data from one database to another as a whole or partially

Powerful visual database designer

Two diagram notations (IDEF1x and IE)

Useful diagram navigation tool

Reverse engineering

Several pages in one diagram to divide diagram into different subject areas

Ability to create, edit and drop tables and table fields, set links between tables visually

Ability to add comments to diagram

Saving as image or printing database diagram

A lot of visual customization options

Easy-to-use wizards performing PostgreSQL maintenance tasks

Analyzing tables

Vacuuming tables

Clustering tables

Reindexing tables

Server Log Viewer

Other useful tools to make your work with PostgreSQL Server as easy as it can be

Database statistics module to view various statistic information on database objects

Extracting metadata into text files or SQL script editor

Powerful print metadata module for creating customizable metadata reports

HTML report wizard to create a detailed HTML report about your database quickly

Report designer for building powerful reports visually

Wizard to download and upload files from/to PostgreSQL server

SQL Monitor

And other useful features

Keyboard templates

To-do list

External tool manager


Requirements:

300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended

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

Possibility to connect to any local or remote PostgreSQL server


Limitations:

Expires in 30 days