Updated on 2023-07-06 GMT+08:00

Other Functions

This section describes the newly added functions of PostgreSQL Enhanced Edition on the basis of PostgreSQL 11 open-source version.

  • Supports the pseudo table DUAL.
    SELECT * FROM DUAL; 
  • Adds the sql_format parameter with the default value postgresql.
  • Optimizes the path management in the CREATE TABLESPACE cloud application scenario, making users being unaware of the actual path.
  • Introduces the pg_hint_plan plugin to enhance query plans and optimize maintenance methods.
  • Provides the data file integrity check tool: pg_verify_checksums.
  • Supports scheduled task management.
  • Enhances the pg_stat_statements plugin.