pg_amop

存储有关索引访问方法操作符类相关操作符信息的目录表

pg_amop 是一个系统目录表，其中存储了有关索引访问方法操作符类相关操作符的信息。

pg_amop 一直存在于 PostgreSQL 中。

按 PostgreSQL 版本定义

pg_amop (PostgreSQL 19)

                 Table "pg_catalog.pg_amop"
     Column     |   Type   | Collation | Nullable | Default 
----------------+----------+-----------+----------+---------
 oid            | oid      |           | not null | 
 amopfamily     | oid      |           | not null | 
 amoplefttype   | oid      |           | not null | 
 amoprighttype  | oid      |           | not null | 
 amopstrategy   | smallint |           | not null | 
 amoppurpose    | "char"   |           | not null | 
 amopopr        | oid      |           | not null | 
 amopmethod     | oid      |           | not null | 
 amopsortfamily | oid      |           | not null | 
Indexes:
    "pg_amop_oid_index" PRIMARY KEY, btree (oid)
    "pg_amop_fam_strat_index" UNIQUE CONSTRAINT, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_opr_fam_index" UNIQUE CONSTRAINT, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 18)

                 Table "pg_catalog.pg_amop"
     Column     |   Type   | Collation | Nullable | Default 
----------------+----------+-----------+----------+---------
 oid            | oid      |           | not null | 
 amopfamily     | oid      |           | not null | 
 amoplefttype   | oid      |           | not null | 
 amoprighttype  | oid      |           | not null | 
 amopstrategy   | smallint |           | not null | 
 amoppurpose    | "char"   |           | not null | 
 amopopr        | oid      |           | not null | 
 amopmethod     | oid      |           | not null | 
 amopsortfamily | oid      |           | not null | 
Indexes:
    "pg_amop_oid_index" PRIMARY KEY, btree (oid)
    "pg_amop_fam_strat_index" UNIQUE CONSTRAINT, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_opr_fam_index" UNIQUE CONSTRAINT, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 17)

                 Table "pg_catalog.pg_amop"
     Column     |   Type   | Collation | Nullable | Default 
----------------+----------+-----------+----------+---------
 oid            | oid      |           | not null | 
 amopfamily     | oid      |           | not null | 
 amoplefttype   | oid      |           | not null | 
 amoprighttype  | oid      |           | not null | 
 amopstrategy   | smallint |           | not null | 
 amoppurpose    | "char"   |           | not null | 
 amopopr        | oid      |           | not null | 
 amopmethod     | oid      |           | not null | 
 amopsortfamily | oid      |           | not null | 
Indexes:
    "pg_amop_oid_index" PRIMARY KEY, btree (oid)
    "pg_amop_fam_strat_index" UNIQUE CONSTRAINT, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_opr_fam_index" UNIQUE CONSTRAINT, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 16)

                 Table "pg_catalog.pg_amop"
     Column     |   Type   | Collation | Nullable | Default 
----------------+----------+-----------+----------+---------
 oid            | oid      |           | not null | 
 amopfamily     | oid      |           | not null | 
 amoplefttype   | oid      |           | not null | 
 amoprighttype  | oid      |           | not null | 
 amopstrategy   | smallint |           | not null | 
 amoppurpose    | "char"   |           | not null | 
 amopopr        | oid      |           | not null | 
 amopmethod     | oid      |           | not null | 
 amopsortfamily | oid      |           | not null | 
Indexes:
    "pg_amop_oid_index" PRIMARY KEY, btree (oid)
    "pg_amop_fam_strat_index" UNIQUE CONSTRAINT, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_opr_fam_index" UNIQUE CONSTRAINT, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 15)

                 Table "pg_catalog.pg_amop"
     Column     |   Type   | Collation | Nullable | Default 
----------------+----------+-----------+----------+---------
 oid            | oid      |           | not null | 
 amopfamily     | oid      |           | not null | 
 amoplefttype   | oid      |           | not null | 
 amoprighttype  | oid      |           | not null | 
 amopstrategy   | smallint |           | not null | 
 amoppurpose    | "char"   |           | not null | 
 amopopr        | oid      |           | not null | 
 amopmethod     | oid      |           | not null | 
 amopsortfamily | oid      |           | not null | 
Indexes:
    "pg_amop_oid_index" PRIMARY KEY, btree (oid)
    "pg_amop_fam_strat_index" UNIQUE CONSTRAINT, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_opr_fam_index" UNIQUE CONSTRAINT, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 14)

                 Table "pg_catalog.pg_amop"
     Column     |   Type   | Collation | Nullable | Default 
----------------+----------+-----------+----------+---------
 oid            | oid      |           | not null | 
 amopfamily     | oid      |           | not null | 
 amoplefttype   | oid      |           | not null | 
 amoprighttype  | oid      |           | not null | 
 amopstrategy   | smallint |           | not null | 
 amoppurpose    | "char"   |           | not null | 
 amopopr        | oid      |           | not null | 
 amopmethod     | oid      |           | not null | 
 amopsortfamily | oid      |           | not null | 
Indexes:
    "pg_amop_oid_index" PRIMARY KEY, btree (oid)
    "pg_amop_fam_strat_index" UNIQUE CONSTRAINT, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_opr_fam_index" UNIQUE CONSTRAINT, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 13)

                 Table "pg_catalog.pg_amop"
     Column     |   Type   | Collation | Nullable | Default 
----------------+----------+-----------+----------+---------
 oid            | oid      |           | not null | 
 amopfamily     | oid      |           | not null | 
 amoplefttype   | oid      |           | not null | 
 amoprighttype  | oid      |           | not null | 
 amopstrategy   | smallint |           | not null | 
 amoppurpose    | "char"   |           | not null | 
 amopopr        | oid      |           | not null | 
 amopmethod     | oid      |           | not null | 
 amopsortfamily | oid      |           | not null | 
Indexes:
    "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_oid_index" UNIQUE, btree (oid)
    "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 12)

                 Table "pg_catalog.pg_amop"
     Column     |   Type   | Collation | Nullable | Default 
----------------+----------+-----------+----------+---------
 oid            | oid      |           | not null | 
 amopfamily     | oid      |           | not null | 
 amoplefttype   | oid      |           | not null | 
 amoprighttype  | oid      |           | not null | 
 amopstrategy   | smallint |           | not null | 
 amoppurpose    | "char"   |           | not null | 
 amopopr        | oid      |           | not null | 
 amopmethod     | oid      |           | not null | 
 amopsortfamily | oid      |           | not null | 
Indexes:
    "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_oid_index" UNIQUE, btree (oid)
    "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 11)

                 Table "pg_catalog.pg_amop"
     Column     |   Type   | Collation | Nullable | Default 
----------------+----------+-----------+----------+---------
 amopfamily     | oid      |           | not null | 
 amoplefttype   | oid      |           | not null | 
 amoprighttype  | oid      |           | not null | 
 amopstrategy   | smallint |           | not null | 
 amoppurpose    | "char"   |           | not null | 
 amopopr        | oid      |           | not null | 
 amopmethod     | oid      |           | not null | 
 amopsortfamily | oid      |           | not null | 
Indexes:
    "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_oid_index" UNIQUE, btree (oid)
    "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 10)

                 Table "pg_catalog.pg_amop"
     Column     |   Type   | Collation | Nullable | Default 
----------------+----------+-----------+----------+---------
 amopfamily     | oid      |           | not null | 
 amoplefttype   | oid      |           | not null | 
 amoprighttype  | oid      |           | not null | 
 amopstrategy   | smallint |           | not null | 
 amoppurpose    | "char"   |           | not null | 
 amopopr        | oid      |           | not null | 
 amopmethod     | oid      |           | not null | 
 amopsortfamily | oid      |           | not null | 
Indexes:
    "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_oid_index" UNIQUE, btree (oid)
    "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 9.6)

      Table "pg_catalog.pg_amop"
     Column     |   Type   | Modifiers 
----------------+----------+-----------
 amopfamily     | oid      | not null
 amoplefttype   | oid      | not null
 amoprighttype  | oid      | not null
 amopstrategy   | smallint | not null
 amoppurpose    | "char"   | not null
 amopopr        | oid      | not null
 amopmethod     | oid      | not null
 amopsortfamily | oid      | not null
Indexes:
    "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_oid_index" UNIQUE, btree (oid)
    "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 9.5)

      Table "pg_catalog.pg_amop"
     Column     |   Type   | Modifiers 
----------------+----------+-----------
 amopfamily     | oid      | not null
 amoplefttype   | oid      | not null
 amoprighttype  | oid      | not null
 amopstrategy   | smallint | not null
 amoppurpose    | "char"   | not null
 amopopr        | oid      | not null
 amopmethod     | oid      | not null
 amopsortfamily | oid      | not null
Indexes:
    "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_oid_index" UNIQUE, btree (oid)
    "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 9.4)

      Table "pg_catalog.pg_amop"
     Column     |   Type   | Modifiers 
----------------+----------+-----------
 amopfamily     | oid      | not null
 amoplefttype   | oid      | not null
 amoprighttype  | oid      | not null
 amopstrategy   | smallint | not null
 amoppurpose    | "char"   | not null
 amopopr        | oid      | not null
 amopmethod     | oid      | not null
 amopsortfamily | oid      | not null
Indexes:
    "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_oid_index" UNIQUE, btree (oid)
    "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 9.3)

      Table "pg_catalog.pg_amop"
     Column     |   Type   | Modifiers 
----------------+----------+-----------
 amopfamily     | oid      | not null
 amoplefttype   | oid      | not null
 amoprighttype  | oid      | not null
 amopstrategy   | smallint | not null
 amoppurpose    | "char"   | not null
 amopopr        | oid      | not null
 amopmethod     | oid      | not null
 amopsortfamily | oid      | not null
Indexes:
    "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_oid_index" UNIQUE, btree (oid)
    "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 9.2)

      Table "pg_catalog.pg_amop"
     Column     |   Type   | Modifiers 
----------------+----------+-----------
 amopfamily     | oid      | not null
 amoplefttype   | oid      | not null
 amoprighttype  | oid      | not null
 amopstrategy   | smallint | not null
 amoppurpose    | "char"   | not null
 amopopr        | oid      | not null
 amopmethod     | oid      | not null
 amopsortfamily | oid      | not null
Indexes:
    "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_oid_index" UNIQUE, btree (oid)
    "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 9.1)

      Table "pg_catalog.pg_amop"
     Column     |   Type   | Modifiers 
----------------+----------+-----------
 amopfamily     | oid      | not null
 amoplefttype   | oid      | not null
 amoprighttype  | oid      | not null
 amopstrategy   | smallint | not null
 amoppurpose    | "char"   | not null
 amopopr        | oid      | not null
 amopmethod     | oid      | not null
 amopsortfamily | oid      | not null
Indexes:
    "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_oid_index" UNIQUE, btree (oid)
    "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 9.0)

      Table "pg_catalog.pg_amop"
    Column     |   Type   | Modifiers 
---------------+----------+-----------
 amopfamily    | oid      | not null
 amoplefttype  | oid      | not null
 amoprighttype | oid      | not null
 amopstrategy  | smallint | not null
 amopopr       | oid      | not null
 amopmethod    | oid      | not null
Indexes:
    "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_oid_index" UNIQUE, btree (oid)
    "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 8.4)

      Table "pg_catalog.pg_amop"
    Column     |   Type   | Modifiers 
---------------+----------+-----------
 amopfamily    | oid      | not null
 amoplefttype  | oid      | not null
 amoprighttype | oid      | not null
 amopstrategy  | smallint | not null
 amopopr       | oid      | not null
 amopmethod    | oid      | not null
Indexes:
    "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_oid_index" UNIQUE, btree (oid)
    "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 8.3)

      Table "pg_catalog.pg_amop"
    Column     |   Type   | Modifiers 
---------------+----------+-----------
 amopfamily    | oid      | not null
 amoplefttype  | oid      | not null
 amoprighttype | oid      | not null
 amopstrategy  | smallint | not null
 amopreqcheck  | boolean  | not null
 amopopr       | oid      | not null
 amopmethod    | oid      | not null
Indexes:
    "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)
    "pg_amop_oid_index" UNIQUE, btree (oid)
    "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amopfamily)

文档: pg_amop

pg_amop (PostgreSQL 8.2)

     Table "pg_catalog.pg_amop"
    Column    |   Type   | Modifiers 
--------------+----------+-----------
 amopclaid    | oid      | not null
 amopsubtype  | oid      | not null
 amopstrategy | smallint | not null
 amopreqcheck | boolean  | not null
 amopopr      | oid      | not null
Indexes:
    "pg_amop_opc_strat_index" UNIQUE, btree (amopclaid, amopsubtype, amopstrategy)
    "pg_amop_opr_opc_index" UNIQUE, btree (amopopr, amopclaid)

文档: pg_amop

变更历史

PostgreSQL 9.1
- 添加了列 amoppurpose (commit 725d52d0)
- 添加了列 amopsortfamily (commit 725d52d0)
PostgreSQL 8.4
- 移除了列 amopreqcheck (commit 9b5c8d45)
PostgreSQL 8.3
- 添加了列 amoplefttype (commit a78fcfb5)
- 添加了列 amoprightype (commit a78fcfb5)
- 添加了列 amopmethod (commit a78fcfb5)
- 移除了列 amopsubtype (commit a78fcfb5)
PostgreSQL 8.0
- 添加了列 amopsubtype (commit fa5c8a05)

注意：列表不包括 PostgreSQL 7.3 之前的任何更改。

示例

pg_amop 的示例记录

postgres=# SELECT * FROM pg_amop LIMIT 1\x\g\x
Expanded display is on.
-[ RECORD 1 ]--+------
oid            | 10118
amopfamily     | 1976
amoplefttype   | 21
amoprighttype  | 21
amopstrategy   | 1
amoppurpose    | s
amopopr        | 95
amopmethod     | 403
amopsortfamily | 0

参考资料

PostgreSQL 文档: pg_amop

另请参阅

pg_am, pg_amproc

反馈

提交关于“pg_amop”的任何评论、建议或更正请在此处。

版本图表

实用概述

有用链接

咖啡

目录

pg_amop

按 PostgreSQL 版本定义

pg_amop (PostgreSQL 19)

pg_amop (PostgreSQL 18)

pg_amop (PostgreSQL 17)

pg_amop (PostgreSQL 16)

pg_amop (PostgreSQL 15)

pg_amop (PostgreSQL 14)

pg_amop (PostgreSQL 13)

pg_amop (PostgreSQL 12)

pg_amop (PostgreSQL 11)

pg_amop (PostgreSQL 10)

pg_amop (PostgreSQL 9.6)

pg_amop (PostgreSQL 9.5)

pg_amop (PostgreSQL 9.4)

pg_amop (PostgreSQL 9.3)

pg_amop (PostgreSQL 9.2)

pg_amop (PostgreSQL 9.1)

pg_amop (PostgreSQL 9.0)

pg_amop (PostgreSQL 8.4)

pg_amop (PostgreSQL 8.3)

pg_amop (PostgreSQL 8.2)

变更历史

示例

参考资料

分类

另请参阅

反馈