{"Entry":{"collection":"func","key":"pg-import-system-collations","name":"pg_import_system_collations","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.6","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"10"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"},{"descriptions_changed":true,"doc_overhaul":false,"from":"13","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"14"},{"descriptions_changed":true,"doc_overhaul":false,"from":"16","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"17"}],"content_hash":"1afb06a9617563663f1842168b9287ac019f5e778c83dd82d9ad26a1c3e23685","first_version":"10","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.517753+08:00","last_version":"20","name":"pg_import_system_collations","name_key":"pg_import_system_collations","position":29043,"present_in":["10","11","12","13","14","15","16","17","18","19","20"],"signature":"pg_import_system_collations ( schema regnamespace ) → integer","signature_count":1,"slug":"pg-import-system-collations","source_rev":"b7bd9cda","summary":"Adds collations to the system catalog pg_collation based on all the locales it finds in the operating system.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-import-system-collations","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-import-system-collations","SourceRevision":"b7bd9cda","Facts":{"description":"Adds collations to the system catalog pg_collation based on all the locales it finds in the operating system. This is what initdb uses; see Section 23.2.2 for more details. If additional locales are installed into the operating system later on, this function can be run again to add collations for the new locales. Locales that match existing entries in pg_collation will be skipped. (But collation objects based on locales that are no longer present in the operating system are not removed by this function.) The schema parameter would typically be pg_catalog, but that is not a requirement; the collations could be installed into some other schema as well. The function returns the number of new collation objects it created. Use of this function is restricted to superusers.","description_html":"Adds collations to the system catalog \u003ccode class=\"structname\"\u003epg_collation\u003c/code\u003e based on all the locales it finds in the operating system. This is what \u003ccode class=\"command\"\u003einitdb\u003c/code\u003e uses; see \u003ca href=\"/docs/18/collation.html#COLLATION-MANAGING\" title=\"23.2.2. Managing Collations\"\u003eSection 23.2.2\u003c/a\u003e for more details. If additional locales are installed into the operating system later on, this function can be run again to add collations for the new locales. Locales that match existing entries in \u003ccode class=\"structname\"\u003epg_collation\u003c/code\u003e will be skipped. (But collation objects based on locales that are no longer present in the operating system are not removed by this function.) The \u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e parameter would typically be \u003ccode class=\"literal\"\u003epg_catalog\u003c/code\u003e, but that is not a requirement; the collations could be installed into some other schema as well. The function returns the number of new collation objects it created. Use of this function is restricted to superusers.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-ADMIN-COLLATION","file":"functions-admin.html","slug":"18"},"group":"admin","group_label":"System Administration Functions","lang":"en","layout":"table-new","pages":["functions-admin.html"],"prose_only":false,"signatures":[{"description":"Adds collations to the system catalog pg_collation based on all the locales it finds in the operating system. This is what initdb uses; see Section 23.2.2 for more details. If additional locales are installed into the operating system later on, this function can be run again to add collations for the new locales. Locales that match existing entries in pg_collation will be skipped. (But collation objects based on locales that are no longer present in the operating system are not removed by this function.) The schema parameter would typically be pg_catalog, but that is not a requirement; the collations could be installed into some other schema as well. The function returns the number of new collation objects it created. Use of this function is restricted to superusers.","description_html":"Adds collations to the system catalog \u003ccode class=\"structname\"\u003epg_collation\u003c/code\u003e based on all the locales it finds in the operating system. This is what \u003ccode class=\"command\"\u003einitdb\u003c/code\u003e uses; see \u003ca href=\"/docs/18/collation.html#COLLATION-MANAGING\" title=\"23.2.2. Managing Collations\"\u003eSection 23.2.2\u003c/a\u003e for more details. If additional locales are installed into the operating system later on, this function can be run again to add collations for the new locales. Locales that match existing entries in \u003ccode class=\"structname\"\u003epg_collation\u003c/code\u003e will be skipped. (But collation objects based on locales that are no longer present in the operating system are not removed by this function.) The \u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e parameter would typically be \u003ccode class=\"literal\"\u003epg_catalog\u003c/code\u003e, but that is not a requirement; the collations could be installed into some other schema as well. The function returns the number of new collation objects it created. Use of this function is restricted to superusers.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_import_system_collations\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eregnamespace\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003einteger\u003c/code\u003e","returns":"integer","text":"pg_import_system_collations ( schema regnamespace ) → integer","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-ADMIN-COLLATION","file":"functions-admin.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-import-system-collations","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_import_system_collations","Summary":"根据操作系统中找到的所有区域设置，向系统目录pg_collation添加排序规则。initdb使用的就是此函数；更多信息见第 23.2.2 节。如果以后在操作系统中安装了其他区域设置，可以再次运行此函数，为新区域设置添加排序规则。与pg_collation中现有条目匹配的区域设置会被跳过。（但此函数不会删除基于操作系统中已不存在的区域设置的排序规则对象。）schema参数通常为pg_catalog，但并非必须如此；也可以将排序规则安装到其他模式中。函数返回新建的排序规则对象数量。此函数仅限超级用户使用。","BodyHTML":"根据操作系统中找到的所有区域设置，向系统目录\u003ccode\u003epg_collation\u003c/code\u003e添加排序规则。\u003ccode\u003einitdb\u003c/code\u003e使用的就是此函数；更多信息见\u003ca href=\"/docs/18/collation.html#COLLATION-MANAGING\" rel=\"nofollow\"\u003e第 23.2.2 节\u003c/a\u003e。如果以后在操作系统中安装了其他区域设置，可以再次运行此函数，为新区域设置添加排序规则。与\u003ccode\u003epg_collation\u003c/code\u003e中现有条目匹配的区域设置会被跳过。（但此函数不会删除基于操作系统中已不存在的区域设置的排序规则对象。）\u003cem\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e参数通常为\u003ccode\u003epg_catalog\u003c/code\u003e，但并非必须如此；也可以将排序规则安装到其他模式中。函数返回新建的排序规则对象数量。此函数仅限超级用户使用。\u003cpre\u003epg_import_system_collations ( schema regnamespace ) → integer\u003c/pre\u003e根据操作系统中找到的所有区域设置，向系统目录\u003ccode\u003epg_collation\u003c/code\u003e添加排序规则。\u003ccode\u003einitdb\u003c/code\u003e使用的就是此函数；更多信息见\u003ca href=\"/docs/18/collation.html#COLLATION-MANAGING\" rel=\"nofollow\"\u003e第 23.2.2 节\u003c/a\u003e。如果以后在操作系统中安装了其他区域设置，可以再次运行此函数，为新区域设置添加排序规则。与\u003ccode\u003epg_collation\u003c/code\u003e中现有条目匹配的区域设置会被跳过。（但此函数不会删除基于操作系统中已不存在的区域设置的排序规则对象。）\u003cem\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e参数通常为\u003ccode\u003epg_catalog\u003c/code\u003e，但并非必须如此；也可以将排序规则安装到其他模式中。函数返回新建的排序规则对象数量。此函数仅限超级用户使用。","SourceRevision":"ca936764","ContentHash":"6fda7e7b2c0d033586d19eeb92165638912b9223a3a7d7f39c80e7b726d26080","Payload":{"description_zh":"根据操作系统中找到的所有区域设置，向系统目录pg_collation添加排序规则。initdb使用的就是此函数；更多信息见第 23.2.2 节。如果以后在操作系统中安装了其他区域设置，可以再次运行此函数，为新区域设置添加排序规则。与pg_collation中现有条目匹配的区域设置会被跳过。（但此函数不会删除基于操作系统中已不存在的区域设置的排序规则对象。）schema参数通常为pg_catalog，但并非必须如此；也可以将排序规则安装到其他模式中。函数返回新建的排序规则对象数量。此函数仅限超级用户使用。","description_zh_html":"根据操作系统中找到的所有区域设置，向系统目录\u003ccode class=\"structname\"\u003epg_collation\u003c/code\u003e添加排序规则。\u003ccode class=\"command\"\u003einitdb\u003c/code\u003e使用的就是此函数；更多信息见\u003ca href=\"/docs/18/collation.html#COLLATION-MANAGING\" title=\"23.2.2. 管理排序规则\"\u003e第 23.2.2 节\u003c/a\u003e。如果以后在操作系统中安装了其他区域设置，可以再次运行此函数，为新区域设置添加排序规则。与\u003ccode class=\"structname\"\u003epg_collation\u003c/code\u003e中现有条目匹配的区域设置会被跳过。（但此函数不会删除基于操作系统中已不存在的区域设置的排序规则对象。）\u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e参数通常为\u003ccode class=\"literal\"\u003epg_catalog\u003c/code\u003e，但并非必须如此；也可以将排序规则安装到其他模式中。函数返回新建的排序规则对象数量。此函数仅限超级用户使用。","signatures":[{"description_zh":"根据操作系统中找到的所有区域设置，向系统目录pg_collation添加排序规则。initdb使用的就是此函数；更多信息见第 23.2.2 节。如果以后在操作系统中安装了其他区域设置，可以再次运行此函数，为新区域设置添加排序规则。与pg_collation中现有条目匹配的区域设置会被跳过。（但此函数不会删除基于操作系统中已不存在的区域设置的排序规则对象。）schema参数通常为pg_catalog，但并非必须如此；也可以将排序规则安装到其他模式中。函数返回新建的排序规则对象数量。此函数仅限超级用户使用。","description_zh_html":"根据操作系统中找到的所有区域设置，向系统目录\u003ccode class=\"structname\"\u003epg_collation\u003c/code\u003e添加排序规则。\u003ccode class=\"command\"\u003einitdb\u003c/code\u003e使用的就是此函数；更多信息见\u003ca href=\"/docs/18/collation.html#COLLATION-MANAGING\" title=\"23.2.2. 管理排序规则\"\u003e第 23.2.2 节\u003c/a\u003e。如果以后在操作系统中安装了其他区域设置，可以再次运行此函数，为新区域设置添加排序规则。与\u003ccode class=\"structname\"\u003epg_collation\u003c/code\u003e中现有条目匹配的区域设置会被跳过。（但此函数不会删除基于操作系统中已不存在的区域设置的排序规则对象。）\u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e参数通常为\u003ccode class=\"literal\"\u003epg_catalog\u003c/code\u003e，但并非必须如此；也可以将排序规则安装到其他模式中。函数返回新建的排序规则对象数量。此函数仅限超级用户使用。","returns":"integer","text":"pg_import_system_collations ( schema regnamespace ) → integer","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"05409f5a9a32a3830d9413b4981050b72bdfe5fb8b5db7f9b0c89a4ddefeb11b","Text":"pg_import_system_collations ( schema regnamespace ) → integer","Returns":"integer","Payload":{"description":"Adds collations to the system catalog pg_collation based on all the locales it finds in the operating system. This is what initdb uses; see Section 23.2.2 for more details. If additional locales are installed into the operating system later on, this function can be run again to add collations for the new locales. Locales that match existing entries in pg_collation will be skipped. (But collation objects based on locales that are no longer present in the operating system are not removed by this function.) The schema parameter would typically be pg_catalog, but that is not a requirement; the collations could be installed into some other schema as well. The function returns the number of new collation objects it created. Use of this function is restricted to superusers.","description_html":"Adds collations to the system catalog \u003ccode class=\"structname\"\u003epg_collation\u003c/code\u003e based on all the locales it finds in the operating system. This is what \u003ccode class=\"command\"\u003einitdb\u003c/code\u003e uses; see \u003ca href=\"/docs/18/collation.html#COLLATION-MANAGING\" title=\"23.2.2. Managing Collations\"\u003eSection 23.2.2\u003c/a\u003e for more details. If additional locales are installed into the operating system later on, this function can be run again to add collations for the new locales. Locales that match existing entries in \u003ccode class=\"structname\"\u003epg_collation\u003c/code\u003e will be skipped. (But collation objects based on locales that are no longer present in the operating system are not removed by this function.) The \u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e parameter would typically be \u003ccode class=\"literal\"\u003epg_catalog\u003c/code\u003e, but that is not a requirement; the collations could be installed into some other schema as well. The function returns the number of new collation objects it created. Use of this function is restricted to superusers.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_import_system_collations\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eschema\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eregnamespace\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003einteger\u003c/code\u003e","returns":"integer","text":"pg_import_system_collations ( schema regnamespace ) → integer","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}