Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ System Catalogs and System Views/ System Views/ ADM_TAB_PARTITIONS
Updated on 2025-07-15 GMT+08:00
View PDF
Share

ADM_TAB_PARTITIONS

ADM_TAB_PARTITIONS displays information about all partitioned tables in the database. By default, only users with the SYSADMIN permission can access this view. Common users can access the view only after being authorized. This view exists in both the PG_CATALOG and SYS schemas.

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