Help Center/GaussDB/Developer Guide(Centralized_V2.0-2.x)/System Catalogs and System Views/System Catalogs/PG_COLLATION
Updated on 2025-08-19 GMT+08:00
View PDF

PG_COLLATION

PG_COLLATION describes available collations, which are essentially mappings from an SQL name to OS local 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

Parent topic:System Catalogs