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 the section called “character_sets
”), so this view does
not provide much useful information.
Table 34.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 |