PG_INDEXES

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

**Table 1** PG_INDEXES columns
Column	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	Index name
tablespace	Name	PG_TABLESPACE.spcname	Name of the tablespace that contains the index
indexdef	Text	N/A	Index definition (a reconstructed CREATE INDEX command)

Query the index information about a specified table.

     SELECT * FROM pg_indexes WHERE tablename = 'user_info';

Click to enlarge

Query information about indexes of all tables in a specified schema in the current database.

     SELECT tablename, indexname, indexdef FROM pg_indexes WHERE schemaname = 'public' ORDER BY tablename,indexname;

Click to enlarge

Parent Topic: System Views

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

For any further questions, feel free to contact us through the chatbot.