pg_partitions

pg_partitions

The pg_partitions system view is used to show the structure of a partitioned table.

Table 1. pg_catalog.pg_partitions

column	type	description
`schemaname`	name	The name of the schema the partitioned table is in.
`tablename`	name	The name of the top-level parent table.
`partitiontablename`	name	The relation name of the partitioned table (this is the table name to use if accessing the partition directly).
`partitionname`	name	The name of the partition (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.
`parentpartitiontablename`	name	The relation name of the parent table one level up from this partition.
`parentpartitionname`	name	The given name of the parent table one level up from this partition.
`partitiontype`	text	The type of partition (range or list).
`partitionlevel`	smallint	The level of this partition 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 partition.
`partitionlistvalues`	text	For list partitions, the list value(s) associated with this partition.
`partitionrangestart`	text	For range partitions, the start value of this partition.
`partitionstartinclusive`	boolean	`T` if the start value is included in this partition. `F` if it is excluded.
`partitionrangeend`	text	For range partitions, the end value of this partition.
`partitionendinclusive`	boolean	`T` if the end value is included in this partition. `F` if it is excluded.
`partitioneveryclause`	text	The `EVERY` clause (interval) of this partition.
`partitionisdefault`	boolean	`T` if this is a default partition, otherwise `F`.
`partitionboundary`	text	The entire partition specification for this partition.