PostgreSQL Maestro 7.6 released

Jun 26, 2007

SQL Maestro Group is happy to announce the release of a new version of PostgreSQL Maestro, a powerful Windows GUI solution for PostgreSQL administration and database development.

Please consider the list of new features implemented in PostgreSQL Maestro 7.6 since last official release:

Server management extensions:

• The most important thing added in this version is support of UTF-8 data.
  
  
• Process Browser is implemented. This feature is very useful for DBAs who want to monitor the users' activity (in fact, there are potentially thousands of sessions in a database at any one time). You can view details for each session (such as user, connect time, database name, client host, last SQL statement executed and more) as well as group and filter sessions by client host, connected user, database, client application, etc.
  To access the Process Browser window, select the corresponding item from the Tools menu.
  
  

• Database Designer: a possibility of locking/unlocking diagram objects is added. This feature prevents your diagram from unforeseen changes: when the diagram is locked, you can neither move/resize/delete existing objects nor add new ones.
  
  
• It is now possible to execute SQL scripts after connect and before disconnect to/from a database.
  
  
• Some new features are incorporated into SQL Editor and SQL Script Editor. Now it is possible:
  
  
  • comment/uncomment selected text (Shift+Ctrl+. / Shift+Ctrl+, shortcuts respectively). If no text is selected, the whole line will be commented. By the way, it is not necessary to select commented text to uncomment it, just press Shift+Ctrl+, having the cursor inside the commented text. Both kinds of comments (single-line and multi-line) are supported;
    
    
  • convert selected text to different cases (lower, UPPER, and NameCase);
    
    
  • export the contents of the editor to RTF and HTML formats (to file or to clipboard);
    
    
  • print/preview the contents of the editor.
    
    
• The Copy to SQL Script Editor command is added to all object editors (available in the Navigation Bar on the SQL tab). Use it for quick copying object’s SQL definition (DDL) to the SQL Script Editor for future modifications;
  
  
• Data grid: some advanced filtering abilities were implemented (see Main menu | Tools | Options | Data grid | Filter);
  
  
• Explorer tree: the Browse command is added to lists' popup menus (runs the Object Browser tool).
  
  

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

Related links:

Back to news archive