PostgreSQL

37.10. `collations`
Prev	Up	Chapter 37. The Information Schema	Home	Next

37.10. `collations`

The view collations contains the collations available in the current database.

Table 37.8. collations Columns

Column Type Description

Column 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
`pad_attribute` `character_data` Always `NO PAD` (The alternative `PAD SPACE` is not supported by PostgreSQL.)

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

pad_attribute character_data

Always NO PAD (The alternative PAD SPACE is not supported by PostgreSQL.)

Prev	Up	Next
37.9. `check_constraints`	Home	37.11. `collation_character_set_applicability`

37.9. check_constraints

Home

37.11. collation_character_set_applicability

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.

PostgreSQL

37.10. collations

Submit correction

37.10. `collations`