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

DB_INDEXES

DB_INDEXES displays information about indexes accessible to the current user. This view exists in both PG_CATALOG and SYS schemas.

Table 1 DB_INDEXES columns

Name

Type

Description

owner

character varying(64)

Index owner.

index_name

character varying(64)

Index name.

table_name

character varying(64)

Name of the table corresponding to the index.

uniqueness

text

Specifies whether the index is unique.

partitioned

character(3)

Specifies whether the index has the property of partitioned tables.

generated

character varying(1)

Specifies whether the name of an index is generated by the system.
Parent topic: System Views