Help Center/ GaussDB(DWS)/ Developer Guide/ Developer Guide (9.1.0.x)/ System Catalogs and System Views/ System Catalogs/ PG_COLLATION
Updated on 2024-09-02 GMT+08:00
View PDF
Share

PG_COLLATION

PG_COLLATION records the 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

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
Parent topic: System Catalogs