September 26, 2024: PostgreSQL 17 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.
37.11. collation_character_set_applicability
Prev  Up Chapter 37. The Information Schema Home  Next

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

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

Prev  Up  Next
37.10. collations  Home  37.12. column_domain_usage