# 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.       |
| `parenttablespace`         | name     |            | The tablespace of parent table.                              |
| `partitiontablespace`      | name     |            | The tablespace of the partation table.                       |