活动专区

活动公告

上车！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_TS_DICT系统表包含定义文本搜索字典的记录。字典取决于文本搜索模板，该模板声明所有需要的实现函数；字典本身提供模板支持的用户可设置的参数的值。这种分工允许字典通过非权限用户创建。参数由文本字符串dictinitoption指定，参数的格式和意义取决于模板。<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:24.9800%;">名称</td><td style="background-color:rgb(215, 215, 215);border:1.0000pt solid windowtext;padding:6.0000pt 9.0000pt;vertical-align:top;width:9.5600%;">类型</td><td style="background-color:rgb(215, 215, 215);border:1.0000pt solid windowtext;padding:6.0000pt 9.0000pt;vertical-align:top;width:31.0000%;">引用</td><td style="background-color:rgb(215, 215, 215);border:1.0000pt solid windowtext;padding:6.0000pt 9.0000pt;vertical-align:top;width:34.4000%;">描述</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:24.9800%;">oid</td><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:9.5600%;">oid</td><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:31.0000%;">-</td><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:34.4000%;">行标识符（隐含属性，必须明确选择）。</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:24.9800%;">dictname</td><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:9.5600%;">name</td><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:31.0000%;">-</td><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:34.4000%;">文本搜索字典名。</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:24.9800%;">dictnamespace</td><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:9.5600%;">oid</td><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:31.0000%;">PG_NAMESPACE.oid</td><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:34.4000%;">包含这个字典的名称空间的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:24.9800%;">dictowner</td><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:9.5600%;">oid</td><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:31.0000%;">PG_AUTHID.oid</td><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:34.4000%;">字典的所有者。</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:24.9800%;">dicttemplate</td><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:9.5600%;">oid</td><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:31.0000%;">PG_TS_TEMPLATE.oid</td><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:34.4000%;">这个字典的文本搜索模板的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:24.9800%;">dictinitoption</td><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:9.5600%;">text</td><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:31.0000%;">-</td><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:34.4000%;">该模板的初始化选项字符串。</td></tr></tbody></table></figure>

GBase 8c

PG_TS_DICT系统表介绍

名称	类型	引用	描述
oid	oid	-	行标识符（隐含属性，必须明确选择）。
dictname	name	-	文本搜索字典名。
dictnamespace	oid	PG_NAMESPACE.oid	包含这个字典的名称空间的OID。
dictowner	oid	PG_AUTHID.oid	字典的所有者。
dicttemplate	oid	PG_TS_TEMPLATE.oid	这个字典的文本搜索模板的OID。
dictinitoption	text	-	该模板的初始化选项字符串。

PG_TS_DICT系统表介绍

热门帖子