{"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":"92a43e6bdb0c0314da36293bb7f6b1cc95904e9cab5e98fc333ca938ecc6fb04","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":"english-manuals:51b04926cc5064b3e254e3871093ff806e95edd92590e517f9cff60201675d04","summary":"The catalog pg_collation describes the available collations, which are essentially mappings from an SQL name to operating system locale categories.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_collation","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_collation","SourceRevision":"english-manuals:51b04926cc5064b3e254e3871093ff806e95edd92590e517f9cff60201675d04","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},{"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},{"array_dimensions":0,"attnum":3,"description":"The OID of the namespace that contains this collation","description_zh":"","documented":true,"documented_name":"collnamespace","hidden":false,"name":"collnamespace","not_null":true,"references":"pg_namespace.oid","type":"oid","type_modifier":-1,"type_oid":26},{"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},{"array_dimensions":0,"attnum":5,"description":"Provider of the collation: d = database default, b = builtin, c = libc, i = icu","description_zh":"","documented":true,"documented_name":"collprovider","hidden":false,"name":"collprovider","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18},{"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},{"array_dimensions":0,"attnum":7,"description":"Encoding in which the collation is applicable, or -1 if it works for any encoding","description_zh":"","documented":true,"documented_name":"collencoding","hidden":false,"name":"collencoding","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"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":"","documented":true,"documented_name":"collcollate","hidden":false,"name":"collcollate","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"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":"","documented":true,"documented_name":"collctype","hidden":false,"name":"collctype","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"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":"","documented":true,"documented_name":"colllocale","hidden":false,"name":"colllocale","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":11,"description":"ICU collation rules for this collation object","description_zh":"","documented":true,"documented_name":"collicurules","hidden":false,"name":"collicurules","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"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}],"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":"","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"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.14.4","file":"catalog-pg-collation.html","lang":"en","sha256":"f1526868172531082adfa9981d7f69a6686e6a9172d53ae889af265801ade1ee","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_collation","Summary":"目录pg_collation描述可用的排序规则，其本质上是从 SQL 名字到操作系统区域设置类别的映射。更多信息参见第 23.2 节。","BodyHTML":"\u003cp\u003e目录pg_collation描述可用的排序规则，其本质上是从 SQL 名字到操作系统区域设置类别的映射。更多信息参见第 23.2 节。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"faef7c62ce71bd994dac1aba84487bbbbb5856b34b71943400c6b4699a4b4882","Payload":{"columns":[{"description_zh":"行标识符","name":"oid","type":"oid","zh_from":"doc"},{"description_zh":"排序规则名称（在每个名字空间与编码的组合内唯一）","name":"collname","type":"name","zh_from":"doc"},{"description_zh":"包含该排序规则的名字空间的OID","name":"collnamespace","type":"oid","zh_from":"doc"},{"description_zh":"排序规则的拥有者","name":"collowner","type":"oid","zh_from":"doc"},{"description_zh":"排序规则提供程序：d = 数据库默认值，b = builtin，c = libc，i = icu","name":"collprovider","type":"\"char\"","zh_from":"doc"},{"description_zh":"排序规则是确定性的吗？","name":"collisdeterministic","type":"boolean","zh_from":"doc"},{"description_zh":"该排序规则可应用的编码，或以-1表示它可用于任何编码","name":"collencoding","type":"integer","zh_from":"doc"},{"description_zh":"此排序规则对象的 LC_COLLATE。如果提供程序不是 libc，则 collcollate 为 NULL，改用 colllocale。","name":"collcollate","type":"text","zh_from":"doc"},{"description_zh":"此排序规则对象的 LC_CTYPE。如果提供程序不是 libc，则 collctype 为 NULL，改用 colllocale。","name":"collctype","type":"text","zh_from":"doc"},{"description_zh":"此排序规则对象的提供程序区域设置名称。如果提供程序是 libc，则 colllocale 为 NULL；改用 collcollate 和 collctype。","name":"colllocale","type":"text","zh_from":"doc"},{"description_zh":"此排序规则对象的 ICU 排序规则","name":"collicurules","type":"text","zh_from":"doc"},{"description_zh":"提供程序特有的排序规则版本。它会在创建排序规则时记录下来，并在使用时接受检查，以检测可能导致数据损坏的排序规则定义更改。","name":"collversion","type":"text","zh_from":"doc"}],"description_zh":"目录pg_collation描述可用的排序规则，其本质上是从 SQL 名字到操作系统区域设置类别的映射。更多信息参见第 23.2 节。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","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}