# pg_partition_templates

The `pg_partition_templates` system view is used to show the subpartitions that were created using a subpartition template.



Table 1. `pg_catalog.pg_partition_templates`

| column                    | type     | references | description                                                  |
| :------------------------ | :------- | :--------- | :----------------------------------------------------------- |
| `schemaname`              | name     |            | The name of the schema the partitioned table is in.          |
| `tablename`               | name     |            | The table name of the top-level parent table.                |
| `partitionname`           | name     |            | The name of the subpartition (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. |
| `partitiontype`           | text     |            | The type of subpartition (range or list).                    |
| `partitionlevel`          | smallint |            | The level of this subpartition 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 subpartition.                |
| `partitionlistvalues`     | text     |            | For list partitions, the list value(s) associated with this subpartition. |
| `partitionrangestart`     | text     |            | For range partitions, the start value of this subpartition.  |
| `partitionstartinclusive` | boolean  |            | `T` if the start value is included in this subpartition. `F` if it is excluded. |
| `partitionrangeend`       | text     |            | For range partitions, the end value of this subpartition.    |
| `partitionendinclusive`   | boolean  |            | `T` if the end value is included in this subpartition. `F` if it is excluded. |
| `partitioneveryclause`    | text     |            | The `EVERY` clause (interval) of this subpartition.          |
| `partitionisdefault`      | boolean  |            | `T` if this is a default subpartition, otherwise `F`.        |
| `partitionboundary`       | text     |            | The entire partition specification for this subpartition.    |