Help Center > > Developer Guide> System Catalogs and System Views> System Views> PG_INDEXES

PG_INDEXES

Updated at: Jul 15, 2020 GMT+08:00

PG_INDEXES displays access to useful information about each index in the database.

Table 1 PG_INDEXES columns

Name

Type

Reference

Description

schemaname

name

PG_NAMESPACE.nspname

Name of the schema that contains tables and indexes

tablename

name

PG_CLASS.relname

Name of the table for which the index serves

indexname

name

PG_CLASS.relname

Name of the index

tablespace

name

PG_TABLESPACE.spcname

Name of the tablespace that contains the index

indexdef

text

-

Index definition (a reconstructed CREATE INDEX command)

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel