PG_COLLATION
PG_COLLATION describes 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, 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
|