PG_PARTITIONED_TABLE v16

The PG_PARTITIONED_TABLE view provides information about how tables are partitioned.

In addition to the information in the PostgreSQL pg_partitioned_table description, EDB Postgres Advanced Server provides the following information.

NameTypeDescription
partdynamicspecpg_node_treeThe dynamic partitioning specification
partnullordersmallintNull ordering for range-partitioned tables
partsubparttemplatepg_node_treeSubpartition number specification