Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Catalogs> PG_COLLATION
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 |
| collcollate | name | - | LC_COLLATE for this collation object |
| collctype | name | - | LC_CTYPE for this collation object |
Parent topic: System Catalogs
Last Article: PG_CLASS
Next Article: PG_CONSTRAINT
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.