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