EMS SQL Manager 2007 Lite for PostgreSQL 4.4.0.6 is a useful and easy-to-use freeware graphical tool for PostgreSQL administration. PostgreSQL Manager works with any PostgreSQL versions up to 8.0 and supports all of the latest PostgreSQL features including tablespaces, named arguments in functions and so on.

EMS SQL Manager 2007 Lite for PostgreSQL is a database manager that helps you administrate PostgreSQL. EMS SQL Manager 2007 has minimal required set of instruments for those users who are new to PostgreSQL server and need only its basic functionality.

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
   • Support of index key sorting order (ASC, DESC; NULLS FIRST, NULLS LAST)
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. Easy-to-use wizards performing PostgreSQL maintenance tasks
    • Analyzing tables
    • Vacuuming tables
    • Clustering tables
    • Reindexing tables
    • Server Log Viewer
11. 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
12. And other useful features
    • Keyboard templates
    • To-do list
    • External tool manager

Enhancements:

• Support of new PostgreSQL 8.3 features
• SQL editors are improved
• A lot of other improvements and bug-fixes

Requirements:

• 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
• Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista
• 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
• Supported PostgreSQL server versions: from 7.3 up to 8.3

EMS SQL Manager for PostgreSQL 4.5 offers you an excellent and easy-to-use product which is a high performance tool for PostgreSQL Database Server administration and development. SQL Manager for PostgreSQL works 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. It 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. SQL Manager for PostgreSQL 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.

Major Features:

1. Works with any PostgreSQL versions up to 8.3
   
2. Supports the latest PostgreSQL features including enumerated, text search, XML and UUID data types, index key sorting order, arrays of composite types, and others
3. 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
4. Has a new state-of-the-art graphical user interface with well-described wizard system

Enhancements:

• Improved Visual Database Designer and DB Explorer
• A lot of new features implemented.

Requirements:

• Pentium 300MHz min
• MS Windows XP, Vista
• 128 MB RAM
• 40 MB HD space

WareSeeker Editor

Microsoft System Center Operations Manager provides end-to-end service management of applications and IT services running across your datacenter fabric, providing you greater and control and insight into the health and performance your Microsoft, UNIX and Linux servers, and the workloads running on them. With Operations Manager 2007 R2 you can reduce the cost of managing your datacenter, and assure delivery of IT services to expected and agreed levels.

Major Features:

1. End-to-End Datacenter Service Management: System Center Operations Manager 2007 R2 helps improve datacenter service performance by improving resolution time through best practice driven alerting, service level monitoring, and reporting.
2. Best of Breed for Windows and Beyond: Extending low cost Windows management to the complete datacenter environment, Operations Manager 2007 R2 provides a single pane of glass across operating systems, hypervisors, network, storage, and Microsoft, UNIX and Linux applications.
3. Increased Efficiency and Control: With automation of routine and redundant tasks, Operations Manager 2007 R2 provides intelligent monitoring and the ability to automate action to help increase efficiency and enable greater control of your IT environment.

Requirements:

1. Supported Operating Systems: Windows Server 2003; Windows Server 2008; Windows Vista; Windows XP
2. For the Microsoft System Center Operations Manager 2007 R2 Management, Web, Database and Reporting Servers:
   • Computer with an x86 or x64 2.8 GHz or faster processor
   • Windows Server 2008 Enterprise, Standard, or Datacenter (x86 or x64) edition or Windows Server 2003 Enterprise, Standard or Datacenter (x86 or x64) edition
   • 4 GB or more RAM; 100 GB or more of available hard-disk space
   • Microsoft SQL Server 2005 Standard or Enterprise edition or Microsoft SQL Server 2008 Standard or Enterprise edition (for the Database Server)
   • Microsoft SQL Server 2005 Standard or Enterprise edition or Microsoft SQL Server 2008 Reporting Services with Service Pack 1 (for the Reporting Server)
   • Microsoft .NET Framework 2.0 and 3.0 (for the Management Server)
   • Microsoft WS-Management 1.1 (for the Management Server)
   • Microsoft Core XML Services (MSXML) 6.0
   • Microsoft Internet Information Services configured with ASP.NET (for the Web Server)
   • Microsoft ASP.NET AJAX 1.0 (for the Web Server)
   • Network adapter
3. For the Microsoft System Center Operations Manager 2007 R2 Consoles:
   • Computer with an x86 or x64 1.8 GHz or faster processor running Windows Vista or
   • Windows XP Professional with Service Pack 1 (or later)
   • 2 GB or more of RAM; 5 GB or more of available hard-disk space
   • Windows PowerShell TM
   • Microsoft .NET Framework 2.0 and 3.0
   • Network adapter

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

Key Features:

• Full support of PostgreSQL up to version 8.1;
• New state-of-the-art graphical user interface;
• Rapid database management and navigation;
• Easy management of all PostgreSQL objects;
• Advanced data manipulation tools;
• Effective security management;
• Excellent visual and text tools for query building;
• Impressive data export and import abilities;
• Powerful visual database designer;
• Easy-to-use wizards performing PostgreSQL maintenance tasks.

dbExpress driver for PostgreSQL 1.00 is an intelligent tool that provides direct high performance access to PostgreSQL database server. It directly connects to the server without using PostgreSQL client software. DbxPgSql supports PostgreSQL server versions since 7.1 up to 8.3.

dbExpress is a database-independent layer that defines common interface to provide fast access to SQL database servers. For each supported server, dbExpress provides a driver as an independent library that implements the common dbExpress interfaces for processing queries and stored procedures. As data-access layer is thin and simple, dbExpress provides high performance database connectivity and is easy to deploy. dbExpress drivers are available for Windows as dynamic-link libraries. When you deploy a database application that uses dbExpress, you need to include only a dll with the application files you've built.

We offer lightweight database drivers for access to Oracle, Microsoft SQL Server, MySQL, PostgreSQL, InterBase, Firebird databases. Using these drivers is the same to using standard dbExpress drivers supplied by Borland.

Major Features:

1. Direct access to data
2. Ability to connect through native protocol without using client software (DbxOda, DbxMda, and DbxPgSql)
3. High performance
4. Supports the latest versions of servers
5. All data types support
6. Extended options for advanced behaviour
7. Complete support for dbExpress version 4
8. Ability of monitoring query execution with DBMonitor
9. Source code available
10. Includes annual Subscription with Priority Support
11. Licensed royalty-free per developer

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, argu

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.

Features of "EMS SQL Manager 2005 for PostgreSQL":

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

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

Changes from previous version

Support of new PostgreSQL 8.3 features (ENUM data types, TSVECTOR, TSQUERY, XML and UUID types, arrays of composite types, index key sorting order (ASC, DESC; NULLS FIRST, NULL)

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: