pg_index

包含索引定义的系统表

pg_index 是一个包含索引定义的系统目录表。

pg_index 在所有 PostgreSQL 版本中都存在。

psql 命令

\di 列出所有索引
\d [PATTERN] 描述一个索引

用法

pg_indexes 提供了 pg_index 部分内容的易读视图。

按 PostgreSQL 版本定义

pg_index (PostgreSQL 19)

                     Table "pg_catalog.pg_index"
       Column        |     Type     | Collation | Nullable | Default 
---------------------+--------------+-----------+----------+---------
 indexrelid          | oid          |           | not null | 
 indrelid            | oid          |           | not null | 
 indnatts            | smallint     |           | not null | 
 indnkeyatts         | smallint     |           | not null | 
 indisunique         | boolean      |           | not null | 
 indnullsnotdistinct | boolean      |           | not null | 
 indisprimary        | boolean      |           | not null | 
 indisexclusion      | boolean      |           | not null | 
 indimmediate        | boolean      |           | not null | 
 indisclustered      | boolean      |           | not null | 
 indisvalid          | boolean      |           | not null | 
 indcheckxmin        | boolean      |           | not null | 
 indisready          | boolean      |           | not null | 
 indislive           | boolean      |           | not null | 
 indisreplident      | boolean      |           | not null | 
 indkey              | int2vector   |           | not null | 
 indcollation        | oidvector    |           | not null | 
 indclass            | oidvector    |           | not null | 
 indoption           | int2vector   |           | not null | 
 indexprs            | pg_node_tree | C         |          | 
 indpred             | pg_node_tree | C         |          | 
Indexes:
    "pg_index_indexrelid_index" PRIMARY KEY, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 18)

                     Table "pg_catalog.pg_index"
       Column        |     Type     | Collation | Nullable | Default 
---------------------+--------------+-----------+----------+---------
 indexrelid          | oid          |           | not null | 
 indrelid            | oid          |           | not null | 
 indnatts            | smallint     |           | not null | 
 indnkeyatts         | smallint     |           | not null | 
 indisunique         | boolean      |           | not null | 
 indnullsnotdistinct | boolean      |           | not null | 
 indisprimary        | boolean      |           | not null | 
 indisexclusion      | boolean      |           | not null | 
 indimmediate        | boolean      |           | not null | 
 indisclustered      | boolean      |           | not null | 
 indisvalid          | boolean      |           | not null | 
 indcheckxmin        | boolean      |           | not null | 
 indisready          | boolean      |           | not null | 
 indislive           | boolean      |           | not null | 
 indisreplident      | boolean      |           | not null | 
 indkey              | int2vector   |           | not null | 
 indcollation        | oidvector    |           | not null | 
 indclass            | oidvector    |           | not null | 
 indoption           | int2vector   |           | not null | 
 indexprs            | pg_node_tree | C         |          | 
 indpred             | pg_node_tree | C         |          | 
Indexes:
    "pg_index_indexrelid_index" PRIMARY KEY, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 17)

                     Table "pg_catalog.pg_index"
       Column        |     Type     | Collation | Nullable | Default 
---------------------+--------------+-----------+----------+---------
 indexrelid          | oid          |           | not null | 
 indrelid            | oid          |           | not null | 
 indnatts            | smallint     |           | not null | 
 indnkeyatts         | smallint     |           | not null | 
 indisunique         | boolean      |           | not null | 
 indnullsnotdistinct | boolean      |           | not null | 
 indisprimary        | boolean      |           | not null | 
 indisexclusion      | boolean      |           | not null | 
 indimmediate        | boolean      |           | not null | 
 indisclustered      | boolean      |           | not null | 
 indisvalid          | boolean      |           | not null | 
 indcheckxmin        | boolean      |           | not null | 
 indisready          | boolean      |           | not null | 
 indislive           | boolean      |           | not null | 
 indisreplident      | boolean      |           | not null | 
 indkey              | int2vector   |           | not null | 
 indcollation        | oidvector    |           | not null | 
 indclass            | oidvector    |           | not null | 
 indoption           | int2vector   |           | not null | 
 indexprs            | pg_node_tree | C         |          | 
 indpred             | pg_node_tree | C         |          | 
Indexes:
    "pg_index_indexrelid_index" PRIMARY KEY, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 16)

                     Table "pg_catalog.pg_index"
       Column        |     Type     | Collation | Nullable | Default 
---------------------+--------------+-----------+----------+---------
 indexrelid          | oid          |           | not null | 
 indrelid            | oid          |           | not null | 
 indnatts            | smallint     |           | not null | 
 indnkeyatts         | smallint     |           | not null | 
 indisunique         | boolean      |           | not null | 
 indnullsnotdistinct | boolean      |           | not null | 
 indisprimary        | boolean      |           | not null | 
 indisexclusion      | boolean      |           | not null | 
 indimmediate        | boolean      |           | not null | 
 indisclustered      | boolean      |           | not null | 
 indisvalid          | boolean      |           | not null | 
 indcheckxmin        | boolean      |           | not null | 
 indisready          | boolean      |           | not null | 
 indislive           | boolean      |           | not null | 
 indisreplident      | boolean      |           | not null | 
 indkey              | int2vector   |           | not null | 
 indcollation        | oidvector    |           | not null | 
 indclass            | oidvector    |           | not null | 
 indoption           | int2vector   |           | not null | 
 indexprs            | pg_node_tree | C         |          | 
 indpred             | pg_node_tree | C         |          | 
Indexes:
    "pg_index_indexrelid_index" PRIMARY KEY, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 15)

                     Table "pg_catalog.pg_index"
       Column        |     Type     | Collation | Nullable | Default 
---------------------+--------------+-----------+----------+---------
 indexrelid          | oid          |           | not null | 
 indrelid            | oid          |           | not null | 
 indnatts            | smallint     |           | not null | 
 indnkeyatts         | smallint     |           | not null | 
 indisunique         | boolean      |           | not null | 
 indnullsnotdistinct | boolean      |           | not null | 
 indisprimary        | boolean      |           | not null | 
 indisexclusion      | boolean      |           | not null | 
 indimmediate        | boolean      |           | not null | 
 indisclustered      | boolean      |           | not null | 
 indisvalid          | boolean      |           | not null | 
 indcheckxmin        | boolean      |           | not null | 
 indisready          | boolean      |           | not null | 
 indislive           | boolean      |           | not null | 
 indisreplident      | boolean      |           | not null | 
 indkey              | int2vector   |           | not null | 
 indcollation        | oidvector    |           | not null | 
 indclass            | oidvector    |           | not null | 
 indoption           | int2vector   |           | not null | 
 indexprs            | pg_node_tree | C         |          | 
 indpred             | pg_node_tree | C         |          | 
Indexes:
    "pg_index_indexrelid_index" PRIMARY KEY, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 14)

                  Table "pg_catalog.pg_index"
     Column     |     Type     | Collation | Nullable | Default 
----------------+--------------+-----------+----------+---------
 indexrelid     | oid          |           | not null | 
 indrelid       | oid          |           | not null | 
 indnatts       | smallint     |           | not null | 
 indnkeyatts    | smallint     |           | not null | 
 indisunique    | boolean      |           | not null | 
 indisprimary   | boolean      |           | not null | 
 indisexclusion | boolean      |           | not null | 
 indimmediate   | boolean      |           | not null | 
 indisclustered | boolean      |           | not null | 
 indisvalid     | boolean      |           | not null | 
 indcheckxmin   | boolean      |           | not null | 
 indisready     | boolean      |           | not null | 
 indislive      | boolean      |           | not null | 
 indisreplident | boolean      |           | not null | 
 indkey         | int2vector   |           | not null | 
 indcollation   | oidvector    |           | not null | 
 indclass       | oidvector    |           | not null | 
 indoption      | int2vector   |           | not null | 
 indexprs       | pg_node_tree | C         |          | 
 indpred        | pg_node_tree | C         |          | 
Indexes:
    "pg_index_indexrelid_index" PRIMARY KEY, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 13)

                  Table "pg_catalog.pg_index"
     Column     |     Type     | Collation | Nullable | Default 
----------------+--------------+-----------+----------+---------
 indexrelid     | oid          |           | not null | 
 indrelid       | oid          |           | not null | 
 indnatts       | smallint     |           | not null | 
 indnkeyatts    | smallint     |           | not null | 
 indisunique    | boolean      |           | not null | 
 indisprimary   | boolean      |           | not null | 
 indisexclusion | boolean      |           | not null | 
 indimmediate   | boolean      |           | not null | 
 indisclustered | boolean      |           | not null | 
 indisvalid     | boolean      |           | not null | 
 indcheckxmin   | boolean      |           | not null | 
 indisready     | boolean      |           | not null | 
 indislive      | boolean      |           | not null | 
 indisreplident | boolean      |           | not null | 
 indkey         | int2vector   |           | not null | 
 indcollation   | oidvector    |           | not null | 
 indclass       | oidvector    |           | not null | 
 indoption      | int2vector   |           | not null | 
 indexprs       | pg_node_tree | C         |          | 
 indpred        | pg_node_tree | C         |          | 
Indexes:
    "pg_index_indexrelid_index" UNIQUE, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 12)

                  Table "pg_catalog.pg_index"
     Column     |     Type     | Collation | Nullable | Default 
----------------+--------------+-----------+----------+---------
 indexrelid     | oid          |           | not null | 
 indrelid       | oid          |           | not null | 
 indnatts       | smallint     |           | not null | 
 indnkeyatts    | smallint     |           | not null | 
 indisunique    | boolean      |           | not null | 
 indisprimary   | boolean      |           | not null | 
 indisexclusion | boolean      |           | not null | 
 indimmediate   | boolean      |           | not null | 
 indisclustered | boolean      |           | not null | 
 indisvalid     | boolean      |           | not null | 
 indcheckxmin   | boolean      |           | not null | 
 indisready     | boolean      |           | not null | 
 indislive      | boolean      |           | not null | 
 indisreplident | boolean      |           | not null | 
 indkey         | int2vector   |           | not null | 
 indcollation   | oidvector    |           | not null | 
 indclass       | oidvector    |           | not null | 
 indoption      | int2vector   |           | not null | 
 indexprs       | pg_node_tree | C         |          | 
 indpred        | pg_node_tree | C         |          | 
Indexes:
    "pg_index_indexrelid_index" UNIQUE, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 11)

                  Table "pg_catalog.pg_index"
     Column     |     Type     | Collation | Nullable | Default 
----------------+--------------+-----------+----------+---------
 indexrelid     | oid          |           | not null | 
 indrelid       | oid          |           | not null | 
 indnatts       | smallint     |           | not null | 
 indnkeyatts    | smallint     |           | not null | 
 indisunique    | boolean      |           | not null | 
 indisprimary   | boolean      |           | not null | 
 indisexclusion | boolean      |           | not null | 
 indimmediate   | boolean      |           | not null | 
 indisclustered | boolean      |           | not null | 
 indisvalid     | boolean      |           | not null | 
 indcheckxmin   | boolean      |           | not null | 
 indisready     | boolean      |           | not null | 
 indislive      | boolean      |           | not null | 
 indisreplident | boolean      |           | not null | 
 indkey         | int2vector   |           | not null | 
 indcollation   | oidvector    |           | not null | 
 indclass       | oidvector    |           | not null | 
 indoption      | int2vector   |           | not null | 
 indexprs       | pg_node_tree |           |          | 
 indpred        | pg_node_tree |           |          | 
Indexes:
    "pg_index_indexrelid_index" UNIQUE, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 10)

                  Table "pg_catalog.pg_index"
     Column     |     Type     | Collation | Nullable | Default 
----------------+--------------+-----------+----------+---------
 indexrelid     | oid          |           | not null | 
 indrelid       | oid          |           | not null | 
 indnatts       | smallint     |           | not null | 
 indisunique    | boolean      |           | not null | 
 indisprimary   | boolean      |           | not null | 
 indisexclusion | boolean      |           | not null | 
 indimmediate   | boolean      |           | not null | 
 indisclustered | boolean      |           | not null | 
 indisvalid     | boolean      |           | not null | 
 indcheckxmin   | boolean      |           | not null | 
 indisready     | boolean      |           | not null | 
 indislive      | boolean      |           | not null | 
 indisreplident | boolean      |           | not null | 
 indkey         | int2vector   |           | not null | 
 indcollation   | oidvector    |           | not null | 
 indclass       | oidvector    |           | not null | 
 indoption      | int2vector   |           | not null | 
 indexprs       | pg_node_tree |           |          | 
 indpred        | pg_node_tree |           |          | 
Indexes:
    "pg_index_indexrelid_index" UNIQUE, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 9.6)

        Table "pg_catalog.pg_index"
     Column     |     Type     | Modifiers 
----------------+--------------+-----------
 indexrelid     | oid          | not null
 indrelid       | oid          | not null
 indnatts       | smallint     | not null
 indisunique    | boolean      | not null
 indisprimary   | boolean      | not null
 indisexclusion | boolean      | not null
 indimmediate   | boolean      | not null
 indisclustered | boolean      | not null
 indisvalid     | boolean      | not null
 indcheckxmin   | boolean      | not null
 indisready     | boolean      | not null
 indislive      | boolean      | not null
 indisreplident | boolean      | not null
 indkey         | int2vector   | not null
 indcollation   | oidvector    | not null
 indclass       | oidvector    | not null
 indoption      | int2vector   | not null
 indexprs       | pg_node_tree | 
 indpred        | pg_node_tree | 
Indexes:
    "pg_index_indexrelid_index" UNIQUE, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 9.5)

        Table "pg_catalog.pg_index"
     Column     |     Type     | Modifiers 
----------------+--------------+-----------
 indexrelid     | oid          | not null
 indrelid       | oid          | not null
 indnatts       | smallint     | not null
 indisunique    | boolean      | not null
 indisprimary   | boolean      | not null
 indisexclusion | boolean      | not null
 indimmediate   | boolean      | not null
 indisclustered | boolean      | not null
 indisvalid     | boolean      | not null
 indcheckxmin   | boolean      | not null
 indisready     | boolean      | not null
 indislive      | boolean      | not null
 indisreplident | boolean      | not null
 indkey         | int2vector   | not null
 indcollation   | oidvector    | not null
 indclass       | oidvector    | not null
 indoption      | int2vector   | not null
 indexprs       | pg_node_tree | 
 indpred        | pg_node_tree | 
Indexes:
    "pg_index_indexrelid_index" UNIQUE, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 9.4)

        Table "pg_catalog.pg_index"
     Column     |     Type     | Modifiers 
----------------+--------------+-----------
 indexrelid     | oid          | not null
 indrelid       | oid          | not null
 indnatts       | smallint     | not null
 indisunique    | boolean      | not null
 indisprimary   | boolean      | not null
 indisexclusion | boolean      | not null
 indimmediate   | boolean      | not null
 indisclustered | boolean      | not null
 indisvalid     | boolean      | not null
 indcheckxmin   | boolean      | not null
 indisready     | boolean      | not null
 indislive      | boolean      | not null
 indisreplident | boolean      | not null
 indkey         | int2vector   | not null
 indcollation   | oidvector    | not null
 indclass       | oidvector    | not null
 indoption      | int2vector   | not null
 indexprs       | pg_node_tree | 
 indpred        | pg_node_tree | 
Indexes:
    "pg_index_indexrelid_index" UNIQUE, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 9.3)

        Table "pg_catalog.pg_index"
     Column     |     Type     | Modifiers 
----------------+--------------+-----------
 indexrelid     | oid          | not null
 indrelid       | oid          | not null
 indnatts       | smallint     | not null
 indisunique    | boolean      | not null
 indisprimary   | boolean      | not null
 indisexclusion | boolean      | not null
 indimmediate   | boolean      | not null
 indisclustered | boolean      | not null
 indisvalid     | boolean      | not null
 indcheckxmin   | boolean      | not null
 indisready     | boolean      | not null
 indislive      | boolean      | not null
 indkey         | int2vector   | not null
 indcollation   | oidvector    | not null
 indclass       | oidvector    | not null
 indoption      | int2vector   | not null
 indexprs       | pg_node_tree | 
 indpred        | pg_node_tree | 
Indexes:
    "pg_index_indexrelid_index" UNIQUE, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 9.2)

        Table "pg_catalog.pg_index"
     Column     |     Type     | Modifiers 
----------------+--------------+-----------
 indexrelid     | oid          | not null
 indrelid       | oid          | not null
 indnatts       | smallint     | not null
 indisunique    | boolean      | not null
 indisprimary   | boolean      | not null
 indisexclusion | boolean      | not null
 indimmediate   | boolean      | not null
 indisclustered | boolean      | not null
 indisvalid     | boolean      | not null
 indcheckxmin   | boolean      | not null
 indisready     | boolean      | not null
 indkey         | int2vector   | not null
 indcollation   | oidvector    | not null
 indclass       | oidvector    | not null
 indoption      | int2vector   | not null
 indexprs       | pg_node_tree | 
 indpred        | pg_node_tree | 
Indexes:
    "pg_index_indexrelid_index" UNIQUE, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 9.1)

        Table "pg_catalog.pg_index"
     Column     |     Type     | Modifiers 
----------------+--------------+-----------
 indexrelid     | oid          | not null
 indrelid       | oid          | not null
 indnatts       | smallint     | not null
 indisunique    | boolean      | not null
 indisprimary   | boolean      | not null
 indisexclusion | boolean      | not null
 indimmediate   | boolean      | not null
 indisclustered | boolean      | not null
 indisvalid     | boolean      | not null
 indcheckxmin   | boolean      | not null
 indisready     | boolean      | not null
 indkey         | int2vector   | not null
 indcollation   | oidvector    | not null
 indclass       | oidvector    | not null
 indoption      | int2vector   | not null
 indexprs       | pg_node_tree | 
 indpred        | pg_node_tree | 
Indexes:
    "pg_index_indexrelid_index" UNIQUE, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 9.0)

       Table "pg_catalog.pg_index"
     Column     |    Type    | Modifiers 
----------------+------------+-----------
 indexrelid     | oid        | not null
 indrelid       | oid        | not null
 indnatts       | smallint   | not null
 indisunique    | boolean    | not null
 indisprimary   | boolean    | not null
 indimmediate   | boolean    | not null
 indisclustered | boolean    | not null
 indisvalid     | boolean    | not null
 indcheckxmin   | boolean    | not null
 indisready     | boolean    | not null
 indkey         | int2vector | not null
 indclass       | oidvector  | not null
 indoption      | int2vector | not null
 indexprs       | text       | 
 indpred        | text       | 
Indexes:
    "pg_index_indexrelid_index" UNIQUE, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 8.4)

       Table "pg_catalog.pg_index"
     Column     |    Type    | Modifiers 
----------------+------------+-----------
 indexrelid     | oid        | not null
 indrelid       | oid        | not null
 indnatts       | smallint   | not null
 indisunique    | boolean    | not null
 indisprimary   | boolean    | not null
 indisclustered | boolean    | not null
 indisvalid     | boolean    | not null
 indcheckxmin   | boolean    | not null
 indisready     | boolean    | not null
 indkey         | int2vector | not null
 indclass       | oidvector  | not null
 indoption      | int2vector | not null
 indexprs       | text       | 
 indpred        | text       | 
Indexes:
    "pg_index_indexrelid_index" UNIQUE, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 8.3)

       Table "pg_catalog.pg_index"
     Column     |    Type    | Modifiers 
----------------+------------+-----------
 indexrelid     | oid        | not null
 indrelid       | oid        | not null
 indnatts       | smallint   | not null
 indisunique    | boolean    | not null
 indisprimary   | boolean    | not null
 indisclustered | boolean    | not null
 indisvalid     | boolean    | not null
 indcheckxmin   | boolean    | not null
 indisready     | boolean    | not null
 indkey         | int2vector | not null
 indclass       | oidvector  | not null
 indoption      | int2vector | not null
 indexprs       | text       | 
 indpred        | text       | 
Indexes:
    "pg_index_indexrelid_index" UNIQUE, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

pg_index (PostgreSQL 8.2)

       Table "pg_catalog.pg_index"
     Column     |    Type    | Modifiers 
----------------+------------+-----------
 indexrelid     | oid        | not null
 indrelid       | oid        | not null
 indnatts       | smallint   | not null
 indisunique    | boolean    | not null
 indisprimary   | boolean    | not null
 indisclustered | boolean    | not null
 indisvalid     | boolean    | not null
 indkey         | int2vector | not null
 indclass       | oidvector  | not null
 indexprs       | text       | 
 indpred        | text       | 
Indexes:
    "pg_index_indexrelid_index" UNIQUE, btree (indexrelid)
    "pg_index_indrelid_index" btree (indrelid)

文档: pg_index

变更历史

注意：此列表不包含 PostgreSQL 7.2 之前的任何更改。

PostgreSQL 18
- 增加了 TOAST 表支持的准备工作（提交 b52c4fc3）
PostgreSQL 15
- 增加了列 indnullsnotdistinct（提交 94aa7cc5）
PostgreSQL 11
- 增加了列 indnkeyatts（提交 8224de4f）
PostgreSQL 9.4
- 增加了列 indisreplident（提交 07cacba9）
PostgreSQL 9.3
- 增加了列 indislive（提交 3c840464）
PostgreSQL 9.1
- 增加了列 indisexclusion（提交 bd1ad1b0）
- 增加了列 indcollation（提交 414c5a2e）
PostgreSQL 9.0
- 增加了列 indimmediate（提交 25d9bf2e）
PostgreSQL 8.3
- 增加了列 indcheckxmin（提交 282d2a03）
- 增加了列 indisready（提交 282d2a03）
- 增加了列 indoption（提交 44317582）
PostgreSQL 8.2
- 增加了列 indisvalid（提交 e093dcdd）
PostgreSQL 8.1
- 列顺序更改（提交 70c9763d）
PostgreSQL 7.4
- 删除了列 indproc（提交 fc8d970c）
- 删除了列 indreference（提交 fc8d970c）
- 增加了列 indnatts（提交 fc8d970c）
- 增加了列 indexprs（提交 fc8d970c）
PostgreSQL 7.2
- 删除了列 indhaskeytype（提交 f933766b）
- 删除了列 indislossy（提交 f933766b）

示例

样本 pg_index 条目

postgres=# CREATE TABLE foo (id INT PRIMARY KEY, val TEXT);
CREATE TABLE

postgres=# SELECT * FROM pg_index WHERE indexrelid = 'foo_pkey'::regclass;
-[ RECORD 1 ]-------+------
indexrelid          | 16398
indrelid            | 16393
indnatts            | 1
indnkeyatts         | 1
indisunique         | t
indnullsnotdistinct | f
indisprimary        | t
indisexclusion      | f
indimmediate        | t
indisclustered      | f
indisvalid          | t
indcheckxmin        | f
indisready          | t
indislive           | t
indisreplident      | f
indkey              | 1
indcollation        | 0
indclass            | 1978
indoption           | 0
indexprs            | 
indpred             |

参考资料

PostgreSQL 文档: pg_index

另请参阅

pg_indexes

反馈

提交您对“pg_index”的任何评论、建议或更正，请在此处 提交。

版本图表

实用概述

有用链接

咖啡

目录

pg_index

psql 命令

用法

按 PostgreSQL 版本定义

pg_index (PostgreSQL 19)

pg_index (PostgreSQL 18)

pg_index (PostgreSQL 17)

pg_index (PostgreSQL 16)

pg_index (PostgreSQL 15)

pg_index (PostgreSQL 14)

pg_index (PostgreSQL 13)

pg_index (PostgreSQL 12)

pg_index (PostgreSQL 11)

pg_index (PostgreSQL 10)

pg_index (PostgreSQL 9.6)

pg_index (PostgreSQL 9.5)

pg_index (PostgreSQL 9.4)

pg_index (PostgreSQL 9.3)

pg_index (PostgreSQL 9.2)

pg_index (PostgreSQL 9.1)

pg_index (PostgreSQL 9.0)

pg_index (PostgreSQL 8.4)

pg_index (PostgreSQL 8.3)

pg_index (PostgreSQL 8.2)

变更历史

示例

参考资料

分类

另请参阅

反馈