pg_partition_rule

pg_partition_rule

The pg_partition_rule system catalog table is used to track partitioned tables, their check constraints, and data containment rules. Each row of pg_partition_rule represents either a leaf partition (the bottom level partitions that contain data), or a branch partition (a top or mid-level partition that is used to define the partition hierarchy, but does not contain any data).

Table 1. pg_catalog.pg_partition_rule

column	type	references	description
`paroid`	oid	pg_partition.oid	Row identifier of the partitioning level (from pg_partition) to which this partition belongs. In the case of a branch partition, the corresponding table (identified by `pg_partition_rule`) is an empty container table. In case of a leaf partition, the table contains the rows for that partition containment rule.
`parchildrelid`	oid	pg_class.oid	The table identifier of the partition (child table).
`parparentrule`	oid	pg_partition_rule.paroid	The row identifier of the rule associated with the parent table of this partition.
`parname`	name		The given name of this partition.
`parisdefault`	boolean		Whether or not this partition is a default partition.
`parruleord`	smallint		For range partitioned tables, the rank of this partition on this level of the partition hierarchy.
`parrangestartincl`	boolean		For range partitioned tables, whether or not the starting value is inclusive.
`parrangeendincl`	boolean		For range partitioned tables, whether or not the ending value is inclusive.
`parrangestart`	text		For range partitioned tables, the starting value of the range.
`parrangeend`	text		For range partitioned tables, the ending value of the range.
`parrangeevery`	text		For range partitioned tables, the interval value of the `EVERY` clause.
`parlistvalues`	text		For list partitioned tables, the list of values assigned to this partition.
`parreloptions`	text		An array describing the storage characteristics of the particular partition.