开源项目 > 其他开源 > 图书/手册/教程 &&

加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

克隆/下载

PG_AMPROC.md 14.15 KB

# PG\_AMPROC<a name="ZH-CN_TOPIC_0289900475"></a>

PG\_AMPROC系统表存储有关与访问方法操作符族相关联的支持过程的信息。每个属于某个操作符族的支持过程都占有一行。

**表 1**  PG\_AMPROC字段

<a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_t7a59d8d60366418a8e3673c9b19c705c"></a>
<table><thead align="left"><tr id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_re40068783670428485d247da42bc401b"><th class="cellrowborder" valign="top" width="21.05%" id="mcps1.2.5.1.1"><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a491f98d50af54064a1d38482330c7b6d"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a491f98d50af54064a1d38482330c7b6d"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a491f98d50af54064a1d38482330c7b6d"></a>名称</p>
</th>
<th class="cellrowborder" valign="top" width="12.030000000000001%" id="mcps1.2.5.1.2"><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a8efe9ef20ad84d9496ad4c9fb62835f9"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a8efe9ef20ad84d9496ad4c9fb62835f9"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a8efe9ef20ad84d9496ad4c9fb62835f9"></a>类型</p>
</th>
<th class="cellrowborder" valign="top" width="25.94%" id="mcps1.2.5.1.3"><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a341f79d9b186448fa161e092cc9cb2cf"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a341f79d9b186448fa161e092cc9cb2cf"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a341f79d9b186448fa161e092cc9cb2cf"></a>引用</p>
</th>
<th class="cellrowborder" valign="top" width="40.98%" id="mcps1.2.5.1.4"><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a1b9f7057915846edb672cd468a3c5ebc"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a1b9f7057915846edb672cd468a3c5ebc"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a1b9f7057915846edb672cd468a3c5ebc"></a>描述</p>
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_r6e4e8c8efc1b439f8e6297a45668aa6b"><td class="cellrowborder" valign="top" width="21.05%" headers="mcps1.2.5.1.1 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_ab94015aa665d4dc781b063307c31c74c"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_ab94015aa665d4dc781b063307c31c74c"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_ab94015aa665d4dc781b063307c31c74c"></a>oid</p>
</td>
<td class="cellrowborder" valign="top" width="12.030000000000001%" headers="mcps1.2.5.1.2 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a5592d3eb591944488141c4ed535f8e50"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a5592d3eb591944488141c4ed535f8e50"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a5592d3eb591944488141c4ed535f8e50"></a>oid</p>
</td>
<td class="cellrowborder" valign="top" width="25.94%" headers="mcps1.2.5.1.3 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a4b184497394d48468c7f95ad0d9c44b4"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a4b184497394d48468c7f95ad0d9c44b4"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a4b184497394d48468c7f95ad0d9c44b4"></a>-</p>
</td>
<td class="cellrowborder" valign="top" width="40.98%" headers="mcps1.2.5.1.4 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a0e42a6f11ee94f9a8f534e7bbbc5a732"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a0e42a6f11ee94f9a8f534e7bbbc5a732"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a0e42a6f11ee94f9a8f534e7bbbc5a732"></a>行标识符（隐含属性，必须明确选择）。</p>
</td>
</tr>
<tr id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_r89e3bcb2ad8f4036b6fb47dab6d13bad"><td class="cellrowborder" valign="top" width="21.05%" headers="mcps1.2.5.1.1 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_ad81abd408a054eb792a1ab101c821f6e"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_ad81abd408a054eb792a1ab101c821f6e"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_ad81abd408a054eb792a1ab101c821f6e"></a>amprocfamily</p>
</td>
<td class="cellrowborder" valign="top" width="12.030000000000001%" headers="mcps1.2.5.1.2 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a8f7257a8a9c84bb29068e3b2e5a0392f"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a8f7257a8a9c84bb29068e3b2e5a0392f"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a8f7257a8a9c84bb29068e3b2e5a0392f"></a>oid</p>
</td>
<td class="cellrowborder" valign="top" width="25.94%" headers="mcps1.2.5.1.3 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a839b492aac624f8dac03b88112d0a8af"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a839b492aac624f8dac03b88112d0a8af"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a839b492aac624f8dac03b88112d0a8af"></a><a href="PG_OPFAMILY.md">PG_OPFAMILY</a>.oid</p>
</td>
<td class="cellrowborder" valign="top" width="40.98%" headers="mcps1.2.5.1.4 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a8abae3c9974e480e8acdfe19a04ad0a0"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a8abae3c9974e480e8acdfe19a04ad0a0"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a8abae3c9974e480e8acdfe19a04ad0a0"></a>该项的操作符族。</p>
</td>
</tr>
<tr id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_rc7bc29f6e4d8410ab3b43755e3b0326a"><td class="cellrowborder" valign="top" width="21.05%" headers="mcps1.2.5.1.1 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_ad643af5751bd45668ecb6237caf23eb9"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_ad643af5751bd45668ecb6237caf23eb9"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_ad643af5751bd45668ecb6237caf23eb9"></a>amproclefttype</p>
</td>
<td class="cellrowborder" valign="top" width="12.030000000000001%" headers="mcps1.2.5.1.2 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a169b75e8600f4a149972cd8dedadcb30"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a169b75e8600f4a149972cd8dedadcb30"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a169b75e8600f4a149972cd8dedadcb30"></a>oid</p>
</td>
<td class="cellrowborder" valign="top" width="25.94%" headers="mcps1.2.5.1.3 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_ad6865fbdec414d1f940666cd5cb0ae5e"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_ad6865fbdec414d1f940666cd5cb0ae5e"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_ad6865fbdec414d1f940666cd5cb0ae5e"></a><a href="PG_TYPE.md">PG_TYPE</a>.oid</p>
</td>
<td class="cellrowborder" valign="top" width="40.98%" headers="mcps1.2.5.1.4 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a0a14b8ebbab0446b978888027039a861"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a0a14b8ebbab0446b978888027039a861"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a0a14b8ebbab0446b978888027039a861"></a>相关操作符的左输入数据类型。可能取值及其描述见于系统表pg_type或查看源码中的pg_type.h文件。</p>
</td>
</tr>
<tr id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_rc15fc41890c64c4fbae83a345bd7466a"><td class="cellrowborder" valign="top" width="21.05%" headers="mcps1.2.5.1.1 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a6c8f488dbcab4be6a84bd2c884c7ae83"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a6c8f488dbcab4be6a84bd2c884c7ae83"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a6c8f488dbcab4be6a84bd2c884c7ae83"></a>amprocrighttype</p>
</td>
<td class="cellrowborder" valign="top" width="12.030000000000001%" headers="mcps1.2.5.1.2 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_af793de1bf1594cf5badd64bad8a9e4a8"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_af793de1bf1594cf5badd64bad8a9e4a8"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_af793de1bf1594cf5badd64bad8a9e4a8"></a>oid</p>
</td>
<td class="cellrowborder" valign="top" width="25.94%" headers="mcps1.2.5.1.3 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a59583e3a3d8446e795b0d389d09997e6"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a59583e3a3d8446e795b0d389d09997e6"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a59583e3a3d8446e795b0d389d09997e6"></a><a href="PG_TYPE.md">PG_TYPE</a>.oid</p>
</td>
<td class="cellrowborder" valign="top" width="40.98%" headers="mcps1.2.5.1.4 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a99330251d63c469582bc507a075e98ab"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a99330251d63c469582bc507a075e98ab"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a99330251d63c469582bc507a075e98ab"></a>相关操作符的右输入数据类型。可能取值及其描述见于系统表pg_type或查看源码中的pg_type.h文件。</p>
</td>
</tr>
<tr id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_r4f9b582d22154188ad45298d86480fcb"><td class="cellrowborder" valign="top" width="21.05%" headers="mcps1.2.5.1.1 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a508feb870222474ba8a341e18f6b9ac6"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a508feb870222474ba8a341e18f6b9ac6"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a508feb870222474ba8a341e18f6b9ac6"></a>amprocnum</p>
</td>
<td class="cellrowborder" valign="top" width="12.030000000000001%" headers="mcps1.2.5.1.2 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a47f6fe1bedfe46b093e4336003103cb4"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a47f6fe1bedfe46b093e4336003103cb4"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a47f6fe1bedfe46b093e4336003103cb4"></a>smallint</p>
</td>
<td class="cellrowborder" valign="top" width="25.94%" headers="mcps1.2.5.1.3 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a06a72c901d564049b9a1c6eab4436947"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a06a72c901d564049b9a1c6eab4436947"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a06a72c901d564049b9a1c6eab4436947"></a>-</p>
</td>
<td class="cellrowborder" valign="top" width="40.98%" headers="mcps1.2.5.1.4 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a57eaebf2220148d699f8c1bd09ca3194"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a57eaebf2220148d699f8c1bd09ca3194"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a57eaebf2220148d699f8c1bd09ca3194"></a>支持过程编号。</p>
</td>
</tr>
<tr id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_r36b10351bf244158b98ec2bda3b911f6"><td class="cellrowborder" valign="top" width="21.05%" headers="mcps1.2.5.1.1 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a24ce566b308b45c39170969f98a28272"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a24ce566b308b45c39170969f98a28272"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a24ce566b308b45c39170969f98a28272"></a>amproc</p>
</td>
<td class="cellrowborder" valign="top" width="12.030000000000001%" headers="mcps1.2.5.1.2 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a7bf244d1c7bf44c2939b7068bf528e14"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a7bf244d1c7bf44c2939b7068bf528e14"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a7bf244d1c7bf44c2939b7068bf528e14"></a>regproc</p>
</td>
<td class="cellrowborder" valign="top" width="25.94%" headers="mcps1.2.5.1.3 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_af972f4a5d69146e78b9ef25deb3f9793"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_af972f4a5d69146e78b9ef25deb3f9793"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_af972f4a5d69146e78b9ef25deb3f9793"></a><a href="PG_PROC.md">PG_PROC</a>.proname</p>
</td>
<td class="cellrowborder" valign="top" width="40.98%" headers="mcps1.2.5.1.4 "><p id="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a61342aed863041489c9b2de211be4209"><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a61342aed863041489c9b2de211be4209"></a><a name="zh-cn_topic_0283136801_zh-cn_topic_0237122269_zh-cn_topic_0059779370_a61342aed863041489c9b2de211be4209"></a>过程的OID。</p>
</td>
</tr>
</tbody>
</table>

amproclefttype和amprocrighttype字段的习惯解释，标识一个特定支持过程支持的操作符的左和右输入类型。对于某些访问方式，匹配支持过程本身的输入数据类型，对其他的则不这样。有一个对索引的“缺省”支持过程的概念，amproclefttype和amprocrighttype都等于索引操作符类的opcintype。

一键复制编辑原始数据按行查看历史

提交于 2023-09-19 09:55 . fix issue

PG_AMPROC

PG_AMPROC系统表存储有关与访问方法操作符族相关联的支持过程的信息。每个属于某个操作符族的支持过程都占有一行。

表 1 PG_AMPROC字段

名称	类型	引用	描述
oid	oid	-	行标识符（隐含属性，必须明确选择）。
amprocfamily	oid	PG_OPFAMILY.oid	该项的操作符族。
amproclefttype	oid	PG_TYPE.oid	相关操作符的左输入数据类型。可能取值及其描述见于系统表pg_type或查看源码中的pg_type.h文件。
amprocrighttype	oid	PG_TYPE.oid	相关操作符的右输入数据类型。可能取值及其描述见于系统表pg_type或查看源码中的pg_type.h文件。
amprocnum	smallint	-	支持过程编号。
amproc	regproc	PG_PROC.proname	过程的OID。

amproclefttype和amprocrighttype字段的习惯解释，标识一个特定支持过程支持的操作符的左和右输入类型。对于某些访问方式，匹配支持过程本身的输入数据类型，对其他的则不这样。有一个对索引的“缺省”支持过程的概念，amproclefttype和amprocrighttype都等于索引操作符类的opcintype。

1

https://gitee.com/opengauss/docs.git

git@gitee.com:opengauss/docs.git

opengauss

docs

docs

3.0.0