Help Center> GaussDB> Distributed_2.x> System Catalogs and System Views> System Views> ADM_TAB_PARTITIONS
Updated on 2023-10-23 GMT+08:00
View PDF

ADM_TAB_PARTITIONS

ADM_TAB_PARTITIONS stores information about all partitions in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

Table 1 ADM_TAB_PARTITIONS columns

Name

Type

Description

table_owner

character varying(64)

Role name

table_name

character varying(64)

Relational table name

partition_name

character varying(64)

Partition name

high_value

text

Upper boundary of the range partition and interval partition

tablespace_name

name

Tablespace name of the partitioned table

schema

character varying(64)

Name of a namespace
Parent topic: System Views