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.
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
