June 27th, 2024: PostgreSQL 17 Beta 2 Released!
Supported Versions: Current (16) / 15 / 14 / 13 / 12
Development Versions: 17 / devel
Unsupported versions: 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.
35.10. collations
Prev  Up Chapter 35. The Information Schema Home  Next

35.10. collations #

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

Table 35.8. collations Columns

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.)

Prev  Up  Next
35.9. check_constraints  Home  35.11. collation_character_set_​applicability