This page in other versions: 9.2 / 9.3 / 9.4 / 9.5 / current (9.6)  |  Development versions: devel  |  Unsupported versions: 7.1 / 7.2 / 7.3 / 7.4 / 8.0 / 8.1 / 8.2 / 8.3 / 8.4 / 9.0 / 9.1

3.9. pg_index

pg_index contains part of the information about indexes. The rest is mostly in pg_class.

Table 3-9. pg_index Columns

Name Type References Description
indexrelid oid pg_class.oid The oid of the pg_class entry for this index
indrelid oid pg_class.oid The oid of the pg_class entry for the table this index is for
indproc oid pg_proc.oid The registered procedure if this is a functional index
indkey int2vector pg_attribute.attnum This is an vector (array) of up to INDEX_MAX_KEYS values that indicate which table columns this index pertains to. For example a value of 1 3 would mean that the first and the third column make up the index key.
indclass oidvector pg_opclass.oid For each column in the index key this contains a reference to the "operator class" to use. See pg_opclass for details.
indisclustered bool   unused
indislossy bool   ???
indisunique bool   If true, this is a unique index.
indisprimary bool   If true, this index is a unique index that represents the primary key of the table.
indreference oid   unused
indpred text   Query plan for partial index predicate (not functional)

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group