PG_COLLATION

NULL: not applicable.
NO PAD: no padding.
PAD SPACE: blank spaces padded at the end.

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
collpadattr	text	-	Collation padding attribute. NULL: not applicable. NO PAD: no padding. PAD SPACE: blank spaces padded at the end.
collisdef	Boolean	-	Determines whether the collation is the default collation of the character set.