---
title: 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).

<a id="topic1__hc179425"></a>
<span class="tablecap">Table 1. pg\_catalog.pg\_partition\_rule</span>


| column              | type     | references                 | description                                                                                                                                                                                                                                                                                                                                                                  |
|---------------------|----------|----------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| `paroid`            | oid      | pg\_partition.oid          | Row identifier of the partitioning level (from [pg\_partition](pg_partition.html#topic1)) 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.                                                                                                                                                                                                                                                                                                 |