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 |
| Row identifier (hidden attribute; must be explicitly selected) |
collname | name |
| 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 |
| Encoding in which the collation is applicable, or -1 if it works for any encoding Note You can use the pg_encoding_to_char() function to convert a number to the corresponding code name. |
collcollate | name |
| LC_COLLATE for this collation object |
collctype | name |
| LC_CTYPE for this collation object |