pg_partition_columns
pg_partition_columns#
The pg_partition_columns system view is used to show the partition key columns of a partitioned table.
Table 1. pg_catalog.pg_partition_columns
column |
type |
references |
description |
|---|---|---|---|
|
name |
The name of the schema the partitioned table is in. |
|
|
name |
The table name of the top-level parent table. |
|
|
name |
The name of the partition key column. |
|
|
smallint |
The level of this subpartition in the hierarchy. |
|
|
integer |
For list partitions you can have a composite (multi-column) partition key. This shows the position of the column in a composite key. |