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.
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 |