vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_04_0579.html
Lu, Huayi e6fa411af0 DWS DEV 830.201 version 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2024-05-16 07:24:04 +00:00

7.9 KiB
Raw Permalink Blame History

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

-

Row 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

NOTE:

You can use the pg_encoding_to_char() function to convert a number to the corresponding code name.

collcollate

name

-

LC_COLLATE for this collation object

collctype

name

-

LC_CTYPE for this collation object
Parent topic: System Catalogs