{"Entry":{"collection":"catalog","key":"pg_collation","name":"pg_collation","aliases":[],"metadata":{"changed_in":["10","12","15","16","17"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.0","order":false,"removed":[],"status":"added","to":"9.1","types":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.5","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.6","types":[],"unlisted":[]},{"added":["collprovider","collversion"],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.6","listing":[],"order":false,"removed":[],"status":"changed","to":"10","types":[],"unlisted":[]},{"added":["collisdeterministic"],"attributes":[{"attribute":"hidden","from":true,"name":"oid","to":false}],"description_changed":false,"descriptions":[],"from":"11","listing":[],"order":false,"removed":[],"status":"changed","to":"12","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]},{"added":["colliculocale"],"attributes":[{"attribute":"not_null","from":true,"name":"collcollate","to":false},{"attribute":"not_null","from":true,"name":"collctype","to":false}],"description_changed":false,"descriptions":[],"from":"14","listing":[],"order":false,"removed":[],"status":"changed","to":"15","types":[{"from":"name","name":"collcollate","to":"text"},{"from":"name","name":"collctype","to":"text"}],"unlisted":[]},{"added":["collicurules"],"attributes":[],"description_changed":false,"descriptions":[],"from":"15","listing":[],"order":false,"removed":[],"status":"changed","to":"16","types":[],"unlisted":[]},{"added":["colllocale"],"attributes":[],"description_changed":true,"descriptions":[{"from":"LC_COLLATE for this collation object","name":"collcollate","to":"LC_COLLATE for this collation object. If the provider is not libc, collcollate is NULL and colllocale is used instead."},{"from":"LC_CTYPE for this collation object","name":"collctype","to":"LC_CTYPE for this collation object. If the provider is not libc, collctype is NULL and colllocale is used instead."},{"from":"Provider of the collation: d = database default, c = libc, i = icu","name":"collprovider","to":"Provider of the collation: d = database default, b = builtin, c = libc, i = icu"}],"from":"16","listing":[],"order":false,"removed":["colliculocale"],"status":"changed","to":"17","types":[],"unlisted":[]}],"column_count":12,"content_hash":"c39058a7e059e7b5f1edf8aed6f8a711735df9129eba9c90e6f508e95bcef74e","derived_content_hash":"a32699ff080d30b1b1336a7169515b9aefcd7184188268e9a6cc734fa7458e44","first_version":"9.1","imported_at":"2026-09-30T00:40:55.43361+08:00","kind":"catalog","last_version":"20","name":"pg_collation","position":15,"present_in":["9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"catalog-bilingual-repair:89a25fe4fd84fa4da10a61a0c0a0422b0c82b194366a214d1b9d2b6f91b4f6c8","summary":"The catalog pg_collation describes the available collations, which are essentially mappings from an SQL name to operating system locale categories.","summary_zh":"目录 pg_collation 描述可用的排序规则，其本质上是从 SQL 名字到操作系统区域设置类别的映射。更多信息参见第 23.2 节。"}},"Definition":{"Collection":"catalog","Key":"pg_collation","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_collation","SourceRevision":"catalog-bilingual-repair:89a25fe4fd84fa4da10a61a0c0a0422b0c82b194366a214d1b9d2b6f91b4f6c8","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"行标识符","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Collation name (unique per namespace and encoding)","description_zh":"排序规则名称（在每个名字空间与编码的组合内唯一）","documented":true,"documented_name":"collname","hidden":false,"name":"collname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"The OID of the namespace that contains this collation","description_zh":"包含该排序规则的名字空间的 OID","documented":true,"documented_name":"collnamespace","hidden":false,"name":"collnamespace","not_null":true,"references":"pg_namespace.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Owner of the collation","description_zh":"排序规则的拥有者","documented":true,"documented_name":"collowner","hidden":false,"name":"collowner","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Provider of the collation: d = database default, b = builtin, c = libc, i = icu","description_zh":"排序规则提供程序：d = 数据库默认值，b = builtin，c = libc，i = icu","documented":true,"documented_name":"collprovider","hidden":false,"name":"collprovider","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Is the collation deterministic?","description_zh":"排序规则是确定性的吗？","documented":true,"documented_name":"collisdeterministic","hidden":false,"name":"collisdeterministic","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Encoding in which the collation is applicable, or -1 if it works for any encoding","description_zh":"该排序规则可应用的编码，或以-1 表示它可用于任何编码","documented":true,"documented_name":"collencoding","hidden":false,"name":"collencoding","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"LC_COLLATE for this collation object. If the provider is not libc, collcollate is NULL and colllocale is used instead.","description_zh":"此排序规则对象的 LC_COLLATE。如果提供程序不是 libc，则 collcollate 为 NULL，改用 colllocale。","documented":true,"documented_name":"collcollate","hidden":false,"name":"collcollate","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"LC_CTYPE for this collation object. If the provider is not libc, collctype is NULL and colllocale is used instead.","description_zh":"此排序规则对象的 LC_CTYPE。如果提供程序不是 libc，则 collctype 为 NULL，改用 colllocale。","documented":true,"documented_name":"collctype","hidden":false,"name":"collctype","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Collation provider locale name for this collation object. If the provider is libc, colllocale is NULL; collcollate and collctype are used instead.","description_zh":"此排序规则对象的提供程序区域设置名称。如果提供程序是 libc，则 colllocale 为 NULL；改用 collcollate 和 collctype。","documented":true,"documented_name":"colllocale","hidden":false,"name":"colllocale","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":11,"description":"ICU collation rules for this collation object","description_zh":"此排序规则对象的 ICU 排序规则","documented":true,"documented_name":"collicurules","hidden":false,"name":"collicurules","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":12,"description":"Provider-specific version of the collation. This is recorded when the collation is created and then checked when it is used, to detect changes in the collation definition that could lead to data corruption.","description_zh":"提供程序特有的排序规则版本。它会在创建排序规则时记录下来，并在使用时接受检查，以检测可能导致数据损坏的排序规则定义更改。","documented":true,"documented_name":"collversion","hidden":false,"name":"collversion","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"The catalog pg_collation describes the available collations, which are essentially mappings from an SQL name to operating system locale categories. See Section 23.2 for more information.","description_zh":"目录 pg_collation 描述可用的排序规则，其本质上是从 SQL 名字到操作系统区域设置类别的映射。更多信息参见第 23.2 节。","description_zh_html":"\u003cp\u003e目录 pg_collation 描述可用的排序规则，其本质上是从 SQL 名字到操作系统区域设置类别的映射。更多信息参见第 23.2 节。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.14.4","file":"catalog-pg-collation.html","lang":"en","sha256":"f1526868172531082adfa9981d7f69a6686e6a9172d53ae889af265801ade1ee","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","collname","collnamespace","collowner","collprovider","collisdeterministic","collencoding","collcollate","collctype","colllocale","collicurules","collversion"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-collation.html","sha256":"d845ab2e4457a153ad225f7eb556508a89e117169f87fbc5f8837e66ee770695","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:51b04926cc5064b3e254e3871093ff806e95edd92590e517f9cff60201675d04","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.14.4","file":"catalog-pg-collation.html","lang":"en","sha256":"f1526868172531082adfa9981d7f69a6686e6a9172d53ae889af265801ade1ee","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-collation.html","sha256":"d845ab2e4457a153ad225f7eb556508a89e117169f87fbc5f8837e66ee770695","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:51b04926cc5064b3e254e3871093ff806e95edd92590e517f9cff60201675d04","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","collname","collnamespace","collowner","collprovider","collisdeterministic","collencoding","collcollate","collctype","colllocale","collicurules","collversion"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_collation","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_collation","Summary":"The catalog pg_collation describes the available collations, which are essentially mappings from an SQL name to operating system locale categories. See Section 23.2 for more information.","BodyHTML":"\u003cp\u003eThe catalog pg_collation describes the available collations, which are essentially mappings from an SQL name to operating system locale categories. See Section 23.2 for more information.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:89a25fe4fd84fa4da10a61a0c0a0422b0c82b194366a214d1b9d2b6f91b4f6c8","ContentHash":"ab9cf2961faab68d67da0c62b150d15b6676d2503005ba1de36690521ed58c9f","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"行标识符","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Collation name (unique per namespace and encoding)","description_zh":"排序规则名称（在每个名字空间与编码的组合内唯一）","documented":true,"documented_name":"collname","hidden":false,"name":"collname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"The OID of the namespace that contains this collation","description_zh":"包含该排序规则的名字空间的 OID","documented":true,"documented_name":"collnamespace","hidden":false,"name":"collnamespace","not_null":true,"references":"pg_namespace.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Owner of the collation","description_zh":"排序规则的拥有者","documented":true,"documented_name":"collowner","hidden":false,"name":"collowner","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Provider of the collation: d = database default, b = builtin, c = libc, i = icu","description_zh":"排序规则提供程序：d = 数据库默认值，b = builtin，c = libc，i = icu","documented":true,"documented_name":"collprovider","hidden":false,"name":"collprovider","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Is the collation deterministic?","description_zh":"排序规则是确定性的吗？","documented":true,"documented_name":"collisdeterministic","hidden":false,"name":"collisdeterministic","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Encoding in which the collation is applicable, or -1 if it works for any encoding","description_zh":"该排序规则可应用的编码，或以-1 表示它可用于任何编码","documented":true,"documented_name":"collencoding","hidden":false,"name":"collencoding","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"LC_COLLATE for this collation object. If the provider is not libc, collcollate is NULL and colllocale is used instead.","description_zh":"此排序规则对象的 LC_COLLATE。如果提供程序不是 libc，则 collcollate 为 NULL，改用 colllocale。","documented":true,"documented_name":"collcollate","hidden":false,"name":"collcollate","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"LC_CTYPE for this collation object. If the provider is not libc, collctype is NULL and colllocale is used instead.","description_zh":"此排序规则对象的 LC_CTYPE。如果提供程序不是 libc，则 collctype 为 NULL，改用 colllocale。","documented":true,"documented_name":"collctype","hidden":false,"name":"collctype","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Collation provider locale name for this collation object. If the provider is libc, colllocale is NULL; collcollate and collctype are used instead.","description_zh":"此排序规则对象的提供程序区域设置名称。如果提供程序是 libc，则 colllocale 为 NULL；改用 collcollate 和 collctype。","documented":true,"documented_name":"colllocale","hidden":false,"name":"colllocale","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":11,"description":"ICU collation rules for this collation object","description_zh":"此排序规则对象的 ICU 排序规则","documented":true,"documented_name":"collicurules","hidden":false,"name":"collicurules","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":12,"description":"Provider-specific version of the collation. This is recorded when the collation is created and then checked when it is used, to detect changes in the collation definition that could lead to data corruption.","description_zh":"提供程序特有的排序规则版本。它会在创建排序规则时记录下来，并在使用时接受检查，以检测可能导致数据损坏的排序规则定义更改。","documented":true,"documented_name":"collversion","hidden":false,"name":"collversion","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"The catalog pg_collation describes the available collations, which are essentially mappings from an SQL name to operating system locale categories. See Section 23.2 for more information."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}