活动专区

活动公告

上车！GBase 8a开发者联盟发车了 技术福利、人脉资源全都有！

认证培训专区

认证培训资料

GBase 8s GDCA 认证培训课前准备

GBase 8a

其他

物化视图报错：references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

01-GBase 8s 事务型数据库 安装与卸载

GBase 8s

适配迁移

[GBase 8s 教程]GBase 8s 常用函数、表达式

PG_USER_MAPPING系统表存储从本地用户到远程的映射。需要有系统管理员权限才可以访问此系统表。普通用户可以使用视图<a href="https://opengauss.org/zh/docs/3.0.0/docs/Developerguide/PG_USER_MAPPINGS.html">PG_USER_MAPPINGS</a>进行查询。<figure class="table" style="width:99.9600%;"><table style=";"><tbody><tr><td style="background-color:rgb(215, 215, 215);border:1.0000pt solid windowtext;padding:6.0000pt 9.0000pt;vertical-align:top;width:15.3000%;">名称</td><td style="background-color:rgb(215, 215, 215);border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top:1.0000pt solid windowtext;padding:6.0000pt 9.0000pt;vertical-align:top;width:11.4800%;">类型</td><td style="background-color:rgb(215, 215, 215);border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top:1.0000pt solid windowtext;padding:6.0000pt 9.0000pt;vertical-align:top;width:28.2200%;">引用</td><td style="background-color:rgb(215, 215, 215);border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top:1.0000pt solid windowtext;padding:6.0000pt 9.0000pt;vertical-align:top;width:44.9600%;">描述</td></tr><tr><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:15.3000%;">oid</td><td style="border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:11.4800%;">oid</td><td style="border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:28.2200%;">-</td><td style="border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:44.9600%;">行标识符（隐含属性，必须明确选择）。</td></tr><tr><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:15.3000%;">umuser</td><td style="border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:11.4800%;">oid</td><td style="border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:28.2200%;">PG_AUTHID.oid</td><td style="border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:44.9600%;">被映射的本地用户的OID，如果用户映射是公共的则为0。</td></tr><tr><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:15.3000%;">umserver</td><td style="border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:11.4800%;">oid</td><td style="border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:28.2200%;">PG_FOREIGN_SERVER.oid</td><td style="border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:44.9600%;">包含这个映射的外部服务器的OID。</td></tr><tr><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:15.3000%;">umoptions</td><td style="border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:11.4800%;">text[]</td><td style="border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:28.2200%;">-</td><td style="border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:44.9600%;">用户映射指定选项，使用“keyword=value”格式的字符串。</td></tr></tbody></table></figure>

GBase 8c

PG_USER_MAPPING系统表说明

名称	类型	引用	描述
oid	oid	-	行标识符（隐含属性，必须明确选择）。
umuser	oid	PG_AUTHID.oid	被映射的本地用户的OID，如果用户映射是公共的则为0。
umserver	oid	PG_FOREIGN_SERVER.oid	包含这个映射的外部服务器的OID。
umoptions	text[]	-	用户映射指定选项，使用“keyword=value”格式的字符串。

PG_USER_MAPPING系统表说明

热门帖子