Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Fred Hildenbrand: "I have purchased MySQL Maestro and like it very much, it has made it much easier to deal with DBA maintenance and table replication as well as a quick way to create SQL statements with the graphical query tool. Good job on a fine product".
Marco De Luca: "I can handle now both version of SQLite Databases, 2.x and 3.x. Your SQLite PHP Generator is among the best tools I have seen".

More

Add your opinion

Customers
SQL Maestro Group / News / All company news / PostgreSQL Maestro 17.8

PostgreSQL Maestro 17.8 released

Aug 19, 2017

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

Please consider the list of new features implemented in this version since the last official release:

New feature highlights:

  • This version of the software has been successfully tested with all the modern database server versions up to PostgreSQL 10 Beta 3 (the latest PostgreSQL version available at the moment).
  • Support for a number of PostgreSQL 10 new features has been implemented as follows:
    • Support for the native table partitioning has been added (PostgreSQL 10). Partitioning refers to splitting what is logically one large table into smaller physical pieces.

      To create a partitioned table, turn ON the appropriate checkbox, then specify the partitioning strategy (Range or List) and the partition key at the Properties tab of Create Table Wizard.

      Creating a partitioned tablePicture 1. Creating a partitioned table
      You can optionally create partitions together with the partitioned table. To do so, switch to the Partitions tab at the third wizard step, then add partitions using the appropriate command from the popup menu.
      Adding partitions to a newly created tablePicture 2. Adding partitions to a newly created table
      To add a new partition to an existing table, open Table Editor, switch to the Partitions tab, then use the "Create New Partition" command at the editor navigation bar or the corresponding item in the partition list's popup menu.
      Adding a partition to an existing tablePicture 3. Adding a partition to an existing table
    • Starting from this version it is possible to rename values of enumeration types.
      Renaming enum valuePicture 4. Renaming enum value
    • Support for identity columns has been added. To add an identity column to a table, open Field Editor and check the appropriate option.
      Field Editor: adding an identity columnPicture 5. Field Editor: adding an identity column
      To customize an identity column, click the "Identity options" link and specify the necessary properties in the modal window.
      Identity column optionsPicture 6. Identity column options
      In data grids and data input forms values of identity fields are filled automatically. The corresponding column headers are marked with the plus sign.
      Identity columns in data gridsPicture 7. Identity columns in data grids
    • Support for restrictive row level security policies has been implemented (the previous versions of PostgreSQL support only permissive policies). By creating restrictive policies, administrators can reduce the set of records which can be accessed as all restrictive policies must be passed for each record.
      Restrictive RLS policyPicture 8. Restrictive RLS policy
  • Starting from this version it is possible to specify a custom label and/or a font color for server nodes in the Database Explorer tree.
    Explorer Tree: custom labels and colorsPicture 9. Explorer Tree: custom labels and colors
    To change these properties, right-click a server node, select "Edit Server Properties" from the popup menu and provide the values you need in the modal dialog.
    Edit Server Properties dialogPicture 10. Edit Server Properties dialog
  • The Statistics tab has been added to the Edit Database Profile dialog. Here you can find such information as profile creation time, total number of connections, last connection time, and so on.
    Database Profile StatisticsPicture 11. Database Profile Statistics
  • Data Grid: now it is possible to copy the value of the selected cell to Clipboard using grid's popup menu or Ctrl+Shift+C shortcut.
    Data Grid: copy cell valuePicture 12. Data Grid: copy cell value
  • "Show special chars" and "Convert tabs to spaces" options have been added to the Editor settings.
    Editor OptionsPicture 13. Editor Options
  • Links to our social networks accounts have been added to the Quick Launch panel. As minor versions are announced only in our Facebook and Twitter, we would recommend you to follow us somewhere to stay informed.
    Follow us!Picture 14. Follow us!

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

Related links

Prev Next
Back to news archive