37.11. 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 37.7), so this view does not provide much useful information.

Table 37.9. collation_character_set_applicability Columns

NameData TypeDescription
collation_catalogsql_identifierName of the database containing the collation (always the current database)
collation_schemasql_identifierName of the schema containing the collation
collation_namesql_identifierName of the default collation
character_set_catalogsql_identifierCharacter sets are currently not implemented as schema objects, so this column is null
character_set_schemasql_identifierCharacter sets are currently not implemented as schema objects, so this column is null
character_set_namesql_identifierName of the character set