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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.