EMS SQL Manager for PostgreSQL 4.5

EMS SQL Manager for PostgreSQL 4.5 is considered as a high performance tool for PostgreSQL Database Server administration and development.

SQL Manager for PostgreSQL can work with any PostgreSQL versions up to 8.3 and supports the latest PostgreSQL features, including enumerated, text search, XML and UUID data types, index key sorting order, arrays of composite types, and others.

Major Features:

1.  Improved Visual Database Designer and DB Explorer
2. A lot of new features implemented
3. Support of UTF8 data
4. Excellent visual and text tools for query building
5. New state-of-the-art graphical user interface
6. Rapid database management and navigation
7. Full support of PostgreSQL up to version 8.3
8. Support of FILLFACTOR parameter for tables and indices
9. Creating indexes concurrently
10. Creating domains based on other domains
11. Support of CONNECT permission for databases and USAGE permission for sequences
12. Changing column types
13. Support of argument names in functions
14. Support of dollar-quoted strings
15. Support of UTF8 data
16. Support of ENUM data types
17. Support of TSVECTOR, TSQUERY, XML and UUID types
18. Support of arrays of composite types
19. Support of index key sorting order (ASC, DESC; NULLS FIRST, NULLS LAST)
20. Improved database explorer for easy management of all PostgreSQL objects
21. Effective security management
22. Impressive data export and import capabilities
23. Powerful visual database designer
24. Easy-to-use wizards performing PostgreSQL maintenance tasks
25. Connecting via local port forwarding through the SSH tunnel
26. Access to PostgreSQL Server through HTTP protocol
27. New state-of-the-art graphica 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
28. 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
29. 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
30. 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
31. Effective securitymanagement
    • EPowerful 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
32. 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)
33. 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
34. 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
35. 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
36. Easy-to-use wizards performing PostgreSQL maintenance task
    • Analyzing tables
    • Vacuuming tables
    • Clustering tables
    • Reindexing tables
    • Server Log Viewer
37. 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
38. Other useful features
    • Keyboard templates
    • To-do list
    • External tool manager

Requirements:

1. Pentium 300MHz min
2. MS Windows XP, Vista
3. 128 MB RAM
4. 40 MB HD space

WareSeeker Editor