pg_partition_templates

The pg_partition_templates system view is used to show the subpartitions that were created using a subpartition template.

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.

Parent topic: System Catalogs Definitions

check-circle-line exclamation-circle-line close-line
Scroll to top icon