Updated on 2025-05-29 GMT+08:00

PG_COLLATION

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

collpadattr

text

-

Collation padding attribute.

  • NULL: not applicable.
  • NO PAD: no padding.
  • PAD SPACE: blank spaces padded at the end.

collisdef

Boolean

-

Determines whether the collation is the default collation of the character set.

id

integer

-

The value is the same as that in the id column queried by running the SHOW COLLATION statement in the MySQL database.