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.