Retrieving information about a partitioned table v16

Suggest edits

EDB Postgres Advanced Server provides five system catalog views that you can use to view information about the structure of partitioned tables.

Querying the partitioning views

You can query the following views to retrieve information about partitioned and subpartitioned tables:

  • ALL_PART_TABLES
  • ALL_TAB_PARTITIONS
  • ALL_TAB_SUBPARTITIONS
  • ALL_PART_KEY_COLUMNS
  • ALL_SUBPART_KEY_COLUMNS

The structure of each view is explained in Table partitioning views reference. If you're using the EDB-PSQL client, you can also learn about the structure of a view by entering:

\d <view_name>

Where view_name specifies the name of the table partitioning view.

Querying a view can provide information about the structure of a partitioned or subpartitioned table. For example, this code displays the names of a subpartitioned table:

edb=# SELECT subpartition_name, partition_name FROM ALL_TAB_SUBPARTITIONS;
Output
 subpartition_name | partition_name
-------------------+----------------
 EUROPE_2011       | EUROPE
 EUROPE_2012       | EUROPE
 ASIA_2011         | ASIA
 ASIA_2012         | ASIA
 AMERICAS_2011     | AMERICAS
 AMERICAS_2012     | AMERICAS
(6 rows)

table_partitioning_views_reference

← Prev

Specifying multiple partitioning keys in a RANGE partitioned table

↑ Up

Using table partitioning

Next →

Optimizing code