PG_COLLATION¶
PG_COLLATION records the available collations, which are essentially mappings from an SQL name to operating system locale categories.
Name | Type | Reference | Description |
---|---|---|---|
OID | OID | N/A | Row identifier (hidden attribute; displayed only when explicitly selected) |
collname | Name | N/A | Collation name (unique per namespace and encoding) |
collnamespace | OID | PG_NAMESPACE.oid | OID of the namespace that contains this collation |
collowner | OID | PG_AUTHID.oid | Owner of the collation |
collencoding | Integer | N/A | Encoding in which the collation is applicable, or -1 if it works for any encoding |
collcollate | Name | N/A | LC_COLLATE for this collation object |
collctype | Name | N/A | LC_CTYPE for this collation object |