• Browse categories
• PostgreSQL releases
  • PostgreSQL 14 (dev)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5
  • PostgreSQL 9.4 (EOL)

Useful articles

Useful links

pg_indexes

pg_indexes is a system catalogue view listing the available indexec in the current database.

pg_indexes was added in PostgreSQL 6.4 (commit f93b6974).

Definition by PostgreSQL version

            View "pg_catalog.pg_indexes"
   Column   | Type | Collation | Nullable | Default
------------+------+-----------+----------+---------
 schemaname | name |           |          |
 tablename  | name |           |          |
 indexname  | name |           |          |
 tablespace | name |           |          |
 indexdef   | text |           |          |
    

            View "pg_catalog.pg_indexes"
   Column   | Type | Collation | Nullable | Default
------------+------+-----------+----------+---------
 schemaname | name |           |          |
 tablename  | name |           |          |
 indexname  | name |           |          |
 tablespace | name |           |          |
 indexdef   | text |           |          |
    

            View "pg_catalog.pg_indexes"
   Column   | Type | Collation | Nullable | Default
------------+------+-----------+----------+---------
 schemaname | name |           |          |
 tablename  | name |           |          |
 indexname  | name |           |          |
 tablespace | name |           |          |
 indexdef   | text |           |          |
    

            View "pg_catalog.pg_indexes"
   Column   | Type | Collation | Nullable | Default
------------+------+-----------+----------+---------
 schemaname | name |           |          |
 tablename  | name |           |          |
 indexname  | name |           |          |
 tablespace | name |           |          |
 indexdef   | text |           |          |
    

 View "pg_catalog.pg_indexes"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 tablename  | name |
 indexname  | name |
 tablespace | name |
 indexdef   | text |
    

 View "pg_catalog.pg_indexes"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 tablename  | name |
 indexname  | name |
 tablespace | name |
 indexdef   | text |
    

 View "pg_catalog.pg_indexes"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 tablename  | name |
 indexname  | name |
 tablespace | name |
 indexdef   | text |
    

 View "pg_catalog.pg_indexes"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 tablename  | name |
 indexname  | name |
 tablespace | name |
 indexdef   | text |
    

 View "pg_catalog.pg_indexes"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 tablename  | name |
 indexname  | name |
 tablespace | name |
 indexdef   | text |
    

 View "pg_catalog.pg_indexes"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 tablename  | name |
 indexname  | name |
 tablespace | name |
 indexdef   | text |
    

 View "pg_catalog.pg_indexes"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 tablename  | name |
 indexname  | name |
 tablespace | name |
 indexdef   | text |
    

 View "pg_catalog.pg_indexes"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 tablename  | name |
 indexname  | name |
 tablespace | name |
 indexdef   | text |
View definition:
 SELECT n.nspname AS schemaname, c.relname AS tablename, i.relname AS indexname, t.spcname AS tablespace, pg_get_indexdef(i.oid) AS indexdef
   FROM pg_index x
   JOIN pg_class c ON c.oid = x.indrelid
   JOIN pg_class i ON i.oid = x.indexrelid
   LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
   LEFT JOIN pg_tablespace t ON t.oid = i.reltablespace
  WHERE c.relkind = 'r'::"char" AND i.relkind = 'i'::"char";
    

 View "pg_catalog.pg_indexes"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 tablename  | name |
 indexname  | name |
 tablespace | name |
 indexdef   | text |
View definition:
 SELECT n.nspname AS schemaname, c.relname AS tablename, i.relname AS indexname, t.spcname AS tablespace, pg_get_indexdef(i.oid) AS indexdef
   FROM pg_index x
   JOIN pg_class c ON c.oid = x.indrelid
   JOIN pg_class i ON i.oid = x.indexrelid
   LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
   LEFT JOIN pg_tablespace t ON t.oid = i.reltablespace
  WHERE c.relkind = 'r'::"char" AND i.relkind = 'i'::"char";
    

 View "pg_catalog.pg_indexes"
   Column   | Type | Modifiers
------------+------+-----------
 schemaname | name |
 tablename  | name |
 indexname  | name |
 tablespace | name |
 indexdef   | text |
View definition:
 SELECT n.nspname AS schemaname, c.relname AS tablename, i.relname AS indexname, t.spcname AS "tablespace", pg_get_indexdef(i.oid) AS indexdef
   FROM pg_index x
   JOIN pg_class c ON c.oid = x.indrelid
   JOIN pg_class i ON i.oid = x.indexrelid
   LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
   LEFT JOIN pg_tablespace t ON t.oid = i.reltablespace
  WHERE c.relkind = 'r'::"char" AND i.relkind = 'i'::"char";
    

Change history

• PostgreSQL 8.0
  • column tablespace added (commit 4690cc9c)
• PostgreSQL 7.3
  • column schemaname added (commit 3b78826b)
• PostgreSQL 6.4
  • added (commit f93b6974)

References

Categories

See also