SYSTEM CATALOGS / SYSTEM CATALOGS
pg_collation
Read PG 18 manual ↗The catalog pg_collation describes the available collations, which are essentially mappings from an SQL name to operating system locale categories.
- Kind
- System catalogs
- Columns in this snapshot
- 12
- Definition source
- English manual
Columns 12
| Column | Type | Description / reference |
|---|---|---|
oid | oid | Row identifier |
collname | name | Collation name (unique per namespace and encoding) |
collnamespace | oid | The OID of the namespace that contains this collation pg_namespace.oid |
collowner | oid | Owner of the collation pg_authid.oid |
collprovider | char | Provider of the collation: d = database default, b = builtin, c = libc, i = icu |
collisdeterministic | bool | Is the collation deterministic? |
collencoding | int4 | Encoding in which the collation is applicable, or -1 if it works for any encoding |
collcollate | text | LC_COLLATE for this collation object. If the provider is not libc, collcollate is NULL and colllocale is used instead. |
collctype | text | LC_CTYPE for this collation object. If the provider is not libc, collctype is NULL and colllocale is used instead. |
colllocale | text | Collation provider locale name for this collation object. If the provider is libc, colllocale is NULL; collcollate and collctype are used instead. |
collicurules | text | ICU collation rules for this collation object |
collversion | text | 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. |
Column history across versions
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
oid | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
collname | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
collnamespace | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
collowner | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
collprovider | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
collencoding | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
collcollate | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
collctype | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
collversion | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
collisdeterministic | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
colliculocale | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | · | · | · | · |
collicurules | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● |
colllocale | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● |
Version history 9
- PG 16 → 17changed
- PG 15 → 16changed
- PG 14 → 15changed
- PG 13 → 14changed
- PG 11 → 12changed
- PG 9.6 → 10changed
- PG 9.5 → 9.6changed
- PG 9.2 → 9.3changed
- PG 9.0 → 9.1added
Definition snapshot: english-manuals:1c81ca250043dabe485e190d140… · English manual source