33.10. collations

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 collations contains the collations available in the current database.

Table 33-8. collations 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
pad_attributecharacter_data Always NO PAD (The alternative PAD SPACE is not supported by PostgreSQL.)