PG_COLLATION
PG_COLLATION describes available collations, which are essentially mappings from an SQL name to operating system locale categories.
Table 1 PG_COLLATION columns
Name | Type | Reference | Description |
---|
oid | oid | - | Row identifier (hidden attribute, which must be specified) |
collname | name | - | Collation name (unique per namespace and encoding) |
collnamespace | oid | OID in PG_NAMESPACE | OID of the namespace that contains this collation |
collowner | oid | OID in PG_AUTHID | Owner of the collation |
collencoding | integer | - | Encoding in which the collation is applicable, or –1 if it works for any encoding. It is compatible with PostgreSQL. |
collcollate | name | - | LC_COLLATE for this collation object |
collctype | name | - | LC_CTYPE for this collation object |
openGauss 2024-09-07 01:01:32