Help Center/ DataArts Fabric/ Developer Guide/ System Catalogs/ PG_COLLATION
Updated on 2025-08-25 GMT+08:00
View PDF
Share

PG_COLLATION

PG_COLLATION describes available collations that essentially map from a SQL name to an operating system locale category.

Table 1 PG_COLLATION columns

Column

Type

Reference

Description

oid

oid

-

Row identifier (a hidden attribute that is only shown upon explicit selection).

collname

name

-

Collation name (unique per namespace and encoding).

collnamespace

oid

PG_NAMESPACE.oid

OID of the namespace containing this collation.

collowner

oid

PG_AUTHID.oid

Owner of the collation.

collencoding

integer

-

Encoding available for the collation, 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