Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PG_COLLATION

PG_COLLATION

Updated at: Jul 15, 2020 GMT+08:00

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

-

Column identifier (hidden attribute; must be explicitly selected)

collname

name

-

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

-

Encoding in which the collation is applicable, or -1 if it works for any encoding

collcollate

name

-

LC_COLLATE for this collation object

collctype

name

-

LC_CTYPE for this collation object

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel