目录

pg_amproc

存储与索引访问方法操作符类关联的支持过程信息的系统表

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

pg_amproc 一直存在于 PostgreSQL 中。

按 PostgreSQL 版本定义

pg_amproc (PostgreSQL 19)

                Table "pg_catalog.pg_amproc"
     Column      |   Type   | Collation | Nullable | Default 
-----------------+----------+-----------+----------+---------
 oid             | oid      |           | not null | 
 amprocfamily    | oid      |           | not null | 
 amproclefttype  | oid      |           | not null | 
 amprocrighttype | oid      |           | not null | 
 amprocnum       | smallint |           | not null | 
 amproc          | regproc  |           | not null | 
Indexes:
    "pg_amproc_oid_index" PRIMARY KEY, btree (oid)
    "pg_amproc_fam_proc_index" UNIQUE CONSTRAINT, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)

文档: pg_amproc

pg_amproc (PostgreSQL 18)

                Table "pg_catalog.pg_amproc"
     Column      |   Type   | Collation | Nullable | Default 
-----------------+----------+-----------+----------+---------
 oid             | oid      |           | not null | 
 amprocfamily    | oid      |           | not null | 
 amproclefttype  | oid      |           | not null | 
 amprocrighttype | oid      |           | not null | 
 amprocnum       | smallint |           | not null | 
 amproc          | regproc  |           | not null | 
Indexes:
    "pg_amproc_oid_index" PRIMARY KEY, btree (oid)
    "pg_amproc_fam_proc_index" UNIQUE CONSTRAINT, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)

文档: pg_amproc

pg_amproc (PostgreSQL 17)

                Table "pg_catalog.pg_amproc"
     Column      |   Type   | Collation | Nullable | Default 
-----------------+----------+-----------+----------+---------
 oid             | oid      |           | not null | 
 amprocfamily    | oid      |           | not null | 
 amproclefttype  | oid      |           | not null | 
 amprocrighttype | oid      |           | not null | 
 amprocnum       | smallint |           | not null | 
 amproc          | regproc  |           | not null | 
Indexes:
    "pg_amproc_oid_index" PRIMARY KEY, btree (oid)
    "pg_amproc_fam_proc_index" UNIQUE CONSTRAINT, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)

文档: pg_amproc

pg_amproc (PostgreSQL 16)

                Table "pg_catalog.pg_amproc"
     Column      |   Type   | Collation | Nullable | Default 
-----------------+----------+-----------+----------+---------
 oid             | oid      |           | not null | 
 amprocfamily    | oid      |           | not null | 
 amproclefttype  | oid      |           | not null | 
 amprocrighttype | oid      |           | not null | 
 amprocnum       | smallint |           | not null | 
 amproc          | regproc  |           | not null | 
Indexes:
    "pg_amproc_oid_index" PRIMARY KEY, btree (oid)
    "pg_amproc_fam_proc_index" UNIQUE CONSTRAINT, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)

文档: pg_amproc

pg_amproc (PostgreSQL 15)

                Table "pg_catalog.pg_amproc"
     Column      |   Type   | Collation | Nullable | Default 
-----------------+----------+-----------+----------+---------
 oid             | oid      |           | not null | 
 amprocfamily    | oid      |           | not null | 
 amproclefttype  | oid      |           | not null | 
 amprocrighttype | oid      |           | not null | 
 amprocnum       | smallint |           | not null | 
 amproc          | regproc  |           | not null | 
Indexes:
    "pg_amproc_oid_index" PRIMARY KEY, btree (oid)
    "pg_amproc_fam_proc_index" UNIQUE CONSTRAINT, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)

文档: pg_amproc

pg_amproc (PostgreSQL 14)

                Table "pg_catalog.pg_amproc"
     Column      |   Type   | Collation | Nullable | Default 
-----------------+----------+-----------+----------+---------
 oid             | oid      |           | not null | 
 amprocfamily    | oid      |           | not null | 
 amproclefttype  | oid      |           | not null | 
 amprocrighttype | oid      |           | not null | 
 amprocnum       | smallint |           | not null | 
 amproc          | regproc  |           | not null | 
Indexes:
    "pg_amproc_oid_index" PRIMARY KEY, btree (oid)
    "pg_amproc_fam_proc_index" UNIQUE CONSTRAINT, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)

文档: pg_amproc

pg_amproc (PostgreSQL 13)

                Table "pg_catalog.pg_amproc"
     Column      |   Type   | Collation | Nullable | Default 
-----------------+----------+-----------+----------+---------
 oid             | oid      |           | not null | 
 amprocfamily    | oid      |           | not null | 
 amproclefttype  | oid      |           | not null | 
 amprocrighttype | oid      |           | not null | 
 amprocnum       | smallint |           | not null | 
 amproc          | regproc  |           | not null | 
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)

文档: pg_amproc

pg_amproc (PostgreSQL 12)

                Table "pg_catalog.pg_amproc"
     Column      |   Type   | Collation | Nullable | Default 
-----------------+----------+-----------+----------+---------
 oid             | oid      |           | not null | 
 amprocfamily    | oid      |           | not null | 
 amproclefttype  | oid      |           | not null | 
 amprocrighttype | oid      |           | not null | 
 amprocnum       | smallint |           | not null | 
 amproc          | regproc  |           | not null | 
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)

文档: pg_amproc

pg_amproc (PostgreSQL 11)

                Table "pg_catalog.pg_amproc"
     Column      |   Type   | Collation | Nullable | Default 
-----------------+----------+-----------+----------+---------
 amprocfamily    | oid      |           | not null | 
 amproclefttype  | oid      |           | not null | 
 amprocrighttype | oid      |           | not null | 
 amprocnum       | smallint |           | not null | 
 amproc          | regproc  |           | not null | 
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)

文档: pg_amproc

pg_amproc (PostgreSQL 10)

                Table "pg_catalog.pg_amproc"
     Column      |   Type   | Collation | Nullable | Default 
-----------------+----------+-----------+----------+---------
 amprocfamily    | oid      |           | not null | 
 amproclefttype  | oid      |           | not null | 
 amprocrighttype | oid      |           | not null | 
 amprocnum       | smallint |           | not null | 
 amproc          | regproc  |           | not null | 
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)

文档: pg_amproc

pg_amproc (PostgreSQL 9.6)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers 
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)

文档: pg_amproc

pg_amproc (PostgreSQL 9.5)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers 
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)

文档: pg_amproc

pg_amproc (PostgreSQL 9.4)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers 
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)

文档: pg_amproc

pg_amproc (PostgreSQL 9.3)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers 
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)

文档: pg_amproc

pg_amproc (PostgreSQL 9.2)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers 
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)

文档: pg_amproc

pg_amproc (PostgreSQL 9.1)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers 
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)

文档: pg_amproc

pg_amproc (PostgreSQL 9.0)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers 
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)

文档: pg_amproc

pg_amproc (PostgreSQL 8.4)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers 
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)

文档: pg_amproc

pg_amproc (PostgreSQL 8.3)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers 
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)

文档: pg_amproc

pg_amproc (PostgreSQL 8.2)

     Table "pg_catalog.pg_amproc"
    Column     |   Type   | Modifiers 
---------------+----------+-----------
 amopclaid     | oid      | not null
 amprocsubtype | oid      | not null
 amprocnum     | smallint | not null
 amproc        | regproc  | not null
Indexes:
    "pg_amproc_opc_proc_index" UNIQUE, btree (amopclaid, amprocsubtype, amprocnum)

文档: pg_amproc

变更历史

  • PostgreSQL 8.3
    • 移除了列 amprocsubtype
    • 添加了列 amproclefttype
    • 添加了列 amprocrighttype
  • PostgreSQL 8.0
    • 添加了列 amprocsubtype

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

示例

postgres=# SELECT * FROM pg_amproc WHERE amproc='btboolcmp'::REGPROC;
  oid  | amprocfamily | amproclefttype | amprocrighttype | amprocnum |  amproc  
-------+--------------+----------------+-----------------+-----------+-----------
 10835 |          424 |             16 |              16 |         1 | btboolcmp
(1 row)

分类

系统目录

另请参阅

pg_am, pg_amop

反馈

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