collation_character_set_applicability The view collation_character_set_applicability
identifies which character set the available collations are
applicable to. In PostgreSQL, there is only one character set per
database (see explanation
in Section 36.7), so this view does
not provide much useful information.
Table 36.9. collation_character_set_applicability Columns
| Name | Data Type | Description |
|---|---|---|
collation_catalog | sql_identifier | Name of the database containing the collation (always the current database) |
collation_schema | sql_identifier | Name of the schema containing the collation |
collation_name | sql_identifier | Name of the default collation |
character_set_catalog | sql_identifier | Character sets are currently not implemented as schema objects, so this column is null |
character_set_schema | sql_identifier | Character sets are currently not implemented as schema objects, so this column is null |
character_set_name | sql_identifier | Name of the character set |