| Postgres-XC 1.2devel Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 33. The Information Schema | Fast Forward | Next |
Note: The following description applies both to Postgres-XC and PostgreSQL if not described explicitly. You can read PostgreSQL as Postgres-XC except for version number, which is specific to each product.
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 33.7), so this view does not provide much useful information.
Table 33-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 |