November 14, 2024: PostgreSQL 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13
Development Versions: devel
Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.
PostgreSQL 9.6.24 Documentation
Prev Up Chapter 35. The Information Schema Next

35.10. collations

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

Table 35-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 Home Next
check_constraints Up collation_character_set_applicability