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 OS 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.
id	integer	-	The value is the same as that in the id column queried by running the SHOW COLLATION statement in the MySQL database.