EMS SQL Manager™ for PostgreSQL
|
Features
EMS SQL Manager 2005 for PostgreSQL is a powerful graphical tool for PostgreSQL Server administration and development. Its easy-to-use graphical interface and a lot of features will make your work with the PostgreSQL as easy as it can be!
pricing starts from $135,00
Overview |
Features |
Screenshots |
Reviews |
Requirements |
Ordering and Licensing |
Downloads |
Ask a Question |
Report a Problem
Features Overview
Full support of PostgreSQL up to version 8.1
- Support of dollar-quoted strings
- Changing column types
- Tablespaces support
- Support of argument names in functions
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 managing 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 databases for working with the required databases only
- 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
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 and syntax highlight
- Large script executing (SQL script editor)
- Ability to view query plan as diagram
- SQL Formatter (Available from SQL Editor context menu)
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, HTML, PDF, TXT, CSV, DBF, XML, etc.
- Exporting data to MS Access
- Importing data from MS Excel, DBF, TXT and CSV
- Importing data from MS Access
- Wizards for copying data from/to file on server
Powerful visual database designer
- Ability to create, edit and drop tables and table fields, set links between tables visually
- Reverse engineering
- Saving as image or printing database diagram
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
- Extracting metadata into text files or SQL script editor
- Powerful print metadata module for creating customizable metadata reports
- Report designer for building powerful reports visually
- SQL Monitor
- HTML report wizard to create a detailed HTML report about your database quickly
And other useful features
- Keyboard templates
- To-do list
- External tool manager
|
Go back to Catalog
DB tools recommendations.
