Updated on 2025-07-15 GMT+08:00

MY_PART_TABLES

MY_PART_TABLES displays information about partitioned tables accessible to the current user. This view exists in both the PG_CATALOG and SYS schemas.

Table 1 MY_PART_TABLES columns

Name

Type

Description

table_owner

character varying(64)

Owner name of a partitioned table.

table_name

character varying(64)

Name of the partitioned table.

partitioning_type

text

Partitioning policy of the partitioned table.

NOTE:

Only range partitioning is supported.

partition_count

bigint

Number of partitions of the partitioned table.

partitioning_key_count

integer

Number of partition keys of the partitioned table.

def_tablespace_name

name

Tablespace name of the partitioned table.

schema

character varying(64)

Schema of the partitioned table.