8th February 2024: PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 Released!
Supported Versions: Current (16) / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1
36.10. collations
Prev  Up Chapter 36. The Information Schema Home  Next

36.10. collations

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

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

Prev  Up  Next
36.9. check_constraints  Home  36.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.