The pg_partitions system view is used to show the structure of a partitioned table.
| 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. | |
partitionschemaname |
name | The namespace of the partition 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 |
text | The tablespace of the parent table one level up from this partition. | |
partitiontablespace |
text | The tablespace of this partition. |
Parent topic: System Catalogs Definitions
