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