EMS SQL Manager for PostgreSQL

What is EMS SQL Manager for PostgreSQL?

EMS SQL Manager for PostgreSQL is a high-performance tool for PostgreSQL database administration and development.

SQL Manager for PostgreSQL offers many powerful database tools, such as Visual Database Designer to create the PostgreSQL database in a few clicks, Visual Query Builder to create complicated PostgreSQL queries, the powerful BLOB editor, and many other useful features for efficient PostgreSQL administration. SQL Manager for PostgreSQL has a state-of-the-art graphical user interface with a well-described wizard system, so clear in use that not even a beginner will be confused with it.

Core features

• Support from PostgreSQL, Amazon RDS for PostgreSQL, Amazon Redshift, Azure Database for PostgreSQL.
• Extension support.
• Support of unregistered tables.
• Excellent visual and text tools for query creation.
• New state-of-the-art graphical user interface.
• Fast database management and navigation.
• Advanced data manipulation tools.
• Enhanced database explorer for easy management of all PostgreSQL objects.
• Effective security management.
• Impressive data export and import capabilities.
• Powerful visual database designer.
• Easy-to-use wizards performing PostgreSQL maintenance tasks.
• Connection via local port routing through the SSH tunnel.
• Access to PostgreSQL Server through the HTTP protocol.
• Management of changes in the database.
• Report designer with report construction wizard.
• Support of partitioned tables.
• JSONB data type support.
• Support for changing foreign key tampering parameters without recreating the key.
• Support for moving all objects from one table space to another.
• Support of materialized views.
• Event trigger support.

System requirements

Microsoft Windows XP, Microsoft Windows Server 2003, Microsoft Windows Server 2008, Microsoft Windows Server 2008 R2, Microsoft Windows Server 2012, Microsoft Windows Server 2012 R2, Microsoft Windows Server 2016, Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8 / 8.1, Microsoft Windows 10

512 Mb of RAM or more; 1024 Mb or more recommended

200 Mb of space available in HD for program installation

Possibility to connect to any local or remote PostgreSQL server