PG_COLLATION

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