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.