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