PG_PARTITIONED_TABLE v18
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.
| Name | Type | Description |
|---|---|---|
| partdynamicspec | pg_node_tree | The dynamic partitioning specification |
| partnullorder | smallint | Null ordering for range-partitioned tables |
| partsubparttemplate | pg_node_tree | Subpartition number specification |