pg_partition_templates

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