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
34.7), 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

Submit correction

If you see anything in the documentation that is not correct, does not match
your experience with the particular feature or requires further clarification,
please use
this form
to report a documentation issue.