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.