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