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	N/A	Row identifier (hidden attribute; displayed only when explicitly selected)
collname	name	N/A	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	N/A	Encoding in which the collation is applicable, or -1 if it works for any encoding
collcollate	name	N/A	LC_COLLATE for this collation object
collctype	name	N/A	LC_CTYPE for this collation object