檢視表 pg_indexes 提供資料庫中每一個索引的資訊。
pg_indexes ColumnsColumn Type
Description
schemaname name (references .nspname)
Name of schema containing table and index
tablename name (references .relname)
Name of table the index is for
indexname name (references .relname)
Name of index
tablespace name (references .spcname)
Name of tablespace containing index (null if default for database)
indexdef text
Index definition (a reconstructed CREATE INDEX command)