PostgreSQL Maestro 7.12 released

Dec 12, 2007

SQL Maestro Group is happy to announce the release of PostgreSQL Maestro 7.12, a powerful Windows GUI solution for PostgreSQL administration and database development. Please consider the list of new features implemented in this version since last official release:

• Support for ENUM types has been added. You can create new such types, edit existing ones and, of course, drop unnecessary types. Also the corresponding editor has been implemented in the Data Grid (also works for domains based on ENUM types, domains based on domains based on ENUM types and so on).
  
  
• Function management: now it is possible to set up the environment for a function as well as customize its execution cost and estimated number of rows returned by a set-returning function.
  
  
• Support for XML and UUID types has been implemented.
  
  

• The Rule permission is no longer displayed for PostgreSQL 8.2+ because it was removed in that release for security reasons.
  
  
• SQL parser now accepts queries with !~~, ~~, ~~* and !~~* operators (SQL Formatter, View Editor).
  
  

• The SQL Generator tool has been implemented. Use this feature to produce various SQL scripts (CREATE, DROP, SELECT, INSERT, etc) for the selected object. The result script can be saved to a file, copied to clipboard, and opened in SQL Editor or SQL Script Editor.
  
  
• Data Grid has been significantly updated:
  
  
  • The notification pane is now displayed after simple mode activation (filtering, grouping and sorting features are not supported in this mode). All the related settings can be customized in the Options dialog.
    
    
  • The Generate Query command has been added to the Table / View Editor. Use this command to copy current filter conditions to the SQL Editor window as an SQL query. It is also possible to copy filter condition to clipboard as WHERE clause using grid’s popup menu.
    
    
  • Now it is possible to encrypt the contents of the selected cell by the md5 algorithm (the corresponding item has been added to grid's popup menu).
    
    
• Database designer: the Note and Text tools have been added. You can use them to decorate the diagrams.
  
  
• Create Database Profiles wizard: the Hide already registered databases option has been added.
  
  
• Object editors, SQL Editor, Database Designer, BLOB Viewer and other database-dependent windows: only connected databases are now displayed in the drop-down list.
  
  

In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.

Related links:

Back to news archive