内容

按 PostgreSQL 版本定义
更改历史记录
示例
参考文献
类别
另请参阅

pg_amop

一个系统表，存储与索引访问方法操作符类关联的操作符信息

pg_amop 是一个系统目录表，存储与索引访问方法操作符类关联的操作符信息。

pg_amop 一直存在于 PostgreSQL 中。

按 PostgreSQL 版本定义

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 (提交 725d52d0)
- 添加了列 amopsortfamily (提交 725d52d0)
PostgreSQL 8.4
- 删除了列 amopreqcheck (提交 9b5c8d45)
PostgreSQL 8.3
- 添加了列 amoplefttype (提交 a78fcfb5)
- 添加了列 amoprightype (提交 a78fcfb5)
- 添加了列 amopmethod (提交 a78fcfb5)
- 删除了列 amopsubtype (提交 a78fcfb5)
PostgreSQL 8.0
- 添加了列 amopsubtype (提交 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 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)

更改历史记录

示例

参考文献

类别

另请参阅

反馈