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