内容

pg_amproc

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

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

pg_amproc 一直存在于 PostgreSQL 中。

按 PostgreSQL 版本定义

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"的任何评论、建议或更正 此处.