pg_partition_templates
The pg_partition_templates system view is used to show the subpartitions that were created using a subpartition template.
Table 1. pg_catalog.pg_partition_templates
| column | type | references | description |
|---|---|---|---|
schemaname |
name | The name of the schema the partitioned table is in. | |
tablename |
name | The table name of the top-level parent table. | |
partitionname |
name | The name of the subpartition (this is the name to use if referring to the partition in an ALTER TABLE command). NULL if the partition was not given a name at create time or generated by an EVERY clause. |
|
partitiontype |
text | The type of subpartition (range or list). | |
partitionlevel |
smallint | The level of this subpartition in the hierarchy. | |
partitionrank |
bigint | For range partitions, the rank of the partition compared to other partitions of the same level. | |
partitionposition |
smallint | The rule order position of this subpartition. | |
partitionlistvalues |
text | For list partitions, the list value(s) associated with this subpartition. | |
partitionrangestart |
text | For range partitions, the start value of this subpartition. | |
partitionstartinclusive |
boolean | T if the start value is included in this subpartition. F if it is excluded. |
|
partitionrangeend |
text | For range partitions, the end value of this subpartition. | |
partitionendinclusive |
boolean | T if the end value is included in this subpartition. F if it is excluded. |
|
partitioneveryclause |
text | The EVERY clause (interval) of this subpartition. |
|
partitionisdefault |
boolean | T if this is a default subpartition, otherwise F. |
|
partitionboundary |
text | The entire partition specification for this subpartition. |