EMS SQL Manager for PostgreSQL Freeware 4.5

EMS SQL Manager for PostgreSQL Freeware 4.5 is a freeware graphical tool for PostgreSQL database administration, and for those users new to PostgreSQL server who need only its basic functionality. SQL Manager Freeware has certain restrictions, such as it can handle not more than 5 databases, etc.

EMS SQL Manager for PostgreSQL works with any PostgreSQL versions up to the newest one and supports the latest PostgreSQL features including enumerated, text search, XML and UUID data types, PostgreSQL index key sorting order, arrays of composite types, and others. SQL Manager for PostgreSQL offers plenty of powerful database tools such as Visual Database Designer to create PostgreSQL database in few clicks, Visual Query Builder to build complicated PostgreSQL queries, powerful BLOB editor and many more useful features for efficient PostgreSQL administration. SQL Manager for PostgreSQL has a 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.

Major Features:

1. Full support of PostgreSQL up to version 8.3
   • 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
   • Support of ENUM data types
   • Support of TSVECTOR, TSQUERY, XML and UUID types
   • Support of arrays of composite types
2. Support of index key sorting order (ASC, DESC; NULLS FIRST, NULLS LAST)
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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)
9. 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
10. 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
11. 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
12. Easy-to-use wizards performing PostgreSQL maintenance tasks
    • Analyzing tables
    • Vacuuming tables
    • Clustering tables
    • Reindexing tables
    • Server Log Viewer
13. 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
14. And other useful features
    • Keyboard templates
    • To-do list
    • External tool manager

Enhancements:

1. Database Registration Info dialog.
   • Most of the options from the Grid | Data Options section of the Environment Options dialog can now be specified individually for each of the registered databases in the Database Registration Info dialog. The values specified in the Grid | Data Options section will be applied as default settings for newly registered databases.
   • The "Schema-organized database tree" option is added. Disabling this option results in creating the object tree without schema division.
   • Metadata and SQL Editor logs can now be saved in UNICODE or ANSI.
2. Query Builder.
   • When a table is added into a query, its foreign key connections to other tables participating in this query are reflected by JOIN statements.
   • In some cases renaming a table and moving to the SQL tab resulted in the “Cannot bind JOIN expression” error. Fixed now.
3. Function Editor
   • The results of functions returning cursor can now be viewed.
   • If the DOUBLE PRECISION argument value was set to “0”, the function execution led to the substitution of this value with “NULL”. Fixed now. 
4. The Unicode support is implemented in function bodies, views, rules, check constraints, object description, field default values, domains, and in a number of object properties.
5. DB Explorer.
   • Many PostgreSQL add-in objects are considered to be system objects and aren’t displayed in the DB Explorer tree if the ‘Show system objects’ option is disabled for the database.
   • The Find Object dialog is improved. 
   • The button for switching the search mode is added to the toolbar.
   • The possibility to reorder hosts using drag-and-drop is implemented.
   • The program saves the information about the last opened database before shutdown. When it is started next time, this database will be automatically selected in the DB Explorer tree.
   • Double-clicking the object group folds or unfolds it.
6. Visual Database Designer. 
   • Tables are arranged more compactly in the reverse engineering mode.
   • Alignment options didn’t work if a diagram was opened from the file.
   • Some printers couldn’t print field and table icons. Fixed now.
7. Data | Blob View. Added the XML tab allowing you to view BLOB field values as XML. 
8. Data Grid. The method of work in the asynchronous mode is changed – the usage of a separate connection for each Data Grid makes it possible to perform simultaneous fetching without losing the ability to use other functions of the program.
9. Extract Database, Export as SQL Script. Now the script is directly generated in the selected charset which reduces the script generation time.
10. HTML Report. The possibility to change the font size for the DDL section is added.
11. View and Rule Editors. When editing a view or rule, the SQL query is formatted with SQL Formatter. DDL of views no more contains extra brackets in expressions.
12. Now a role can be set as an object owner (available for PostgreSQL version 8.1 and higher).
13. Window List. The ‘Close All Database Windows’ command is implemented.
14. Foreign Key Editor. Now there is a possibility to view or edit foreign key descriptions.
15. The ‘Serial fields as integer’ option value is now taken into account not only in table DDL, but also in all cases when the field type is displayed.
16. A new option was added to the Object Editors tab of Environment Options dialog. It allows you to define whether to split function options into several lines in DDL or to display all options in one line.
17. Table Editor. Export Data, Import Data and Export as SQL Script wizards can be now accessed from the editor toolbar even if the data tab is not active.
18. Save Settings wizard. Now when saving settings to the existing file, the program suggests you to overwrite the file or make the new file unique by adding the current date and time to the file name.
19. Check Constraint Editor. Now the size of the editor window can be changed; it is also remembered for future launches.
20. Data Grid. The mouse cursor color changes if the grid is not active.
21. SQL Editor. Creation of queries with identical names was allowed. Fixed now.
22. Code Parameters. 
    • Code parameters weren’t sometimes displayed for the second and further function arguments. Fixed now.
    • If several functions were created with the same names but different arguments, code parameters were shown only for one of these functions. Fixed now.
    • If the automatic display of code parameters was disabled, it was impossible to access parameters even with the Ctrl+Shift+Space shortcut. Fixed now.
23. User-defined type arrays used to be displayed improperly in DDL. Fixed now.
24. SQL Editor. 
    • Several errors concerning SQL code highlighting were fixed.
    • When saving data to file using any charset different from Unicode, further opening of the save dialogue would set charset to Unicode. Fixed now. 
25. If an error occurred on saving an object while using HTTP tunneling, it was not displayed at the Changing Metadata window. This made possible to commit changes, though no changes were really made.
26. Relations of composite and table types with other objects were not displayed in the Dependency Tree and at the Dependency tab. Fixed now.
27. When editing or deleting a record containing polygon and/or point field, an error sometimes occurred. Fixed now.
28. Function Debugger. Syntax error occurred on opening function with FOR … IN construction. Fixed now.
29. Numeric fields of high precision used to be edited and displayed incorrectly in the data grid. Fixed now.
30. SERIAL fields’ sequences values were not restored after reordering of columns. Fixed now.
31. Editing money fields resulted in an error if PostgreSQL server parameters were set in a specific way. Fixed now.
32. Database Properties. An error occurred on saving a database whose description contained the character “”. Fixed now.
33. Other small improvements and bugfixes.

Requirements: