SQL Examiner Suite 2023.2 release notes

May 31, 2023

After the major SQL Examiner Suite 2023 release, several feature updates have been added. All interim features are available free of charge to users who already own the 2023 version.

The primary SQL Examiner Suite 2023 Release Notes contain all features planned for version 2023. Here we list features implemented in 2023.2. The rest are available in the articles:

• SQL Examiner Suite 2023.1 release notes
• SQL Examiner Suite 2023.3 release notes

Version 2023.2 includes SQL Examiner and SQL Data Examiner with version numbers 9.2.x.x.

In this release, we have implemented support for the following features of PostgreSQL 15 and 14:

• Multirange types:
  https://www.postgresql.org/docs/current/rangetypes.html
• COMPRESSION clause for table columns
  https://www.postgresql.org/docs/15/sql-createtable.html
• OUT parameters in stored procedures

We also added support for previously unsupported features of earlier versions of PostgreSQL:

• RULE objects:
  https://www.postgresql.org/docs/15/sql-createrule.html
• STORAGE (SET STORAGE in column definition) mode for columns:
  https://www.postgresql.org/docs/15/sql-altertable.html
• Statistics-gathering target (SET STATISTICS in column definition) for columns
  https://www.postgresql.org/docs/15/sql-altertable.html
• Per-attribute options for table columns:
  https://www.postgresql.org/docs/15/sql-altertable.html
• Extensions:
  https://www.postgresql.org/docs/15/sql-createextension.html
  Although SQL Examiner cannot compare and synchronize extensions, the program compares the list of extensions and their versions and warns if source and target databases differ.
• Support of the UNLOGGED parameter for tables and sequences:
  https://www.postgresql.org/docs/15/sql-altersequence.html