内容

psql命令
按PostgreSQL版本定义
更改历史记录
参考文献
分类
另请参阅

pg_index

包含索引定义的系统表

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

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

psql命令

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

按PostgreSQL版本定义

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 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)

参考文献

PostgreSQL 文档： pg_index

另请参阅

pg_indexes

反馈

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

版本图表

有用概述

有用链接

咖啡

内容

pg_index

psql命令

按PostgreSQL版本定义

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)

更改历史记录

参考文献

分类

另请参阅

反馈