↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1
Historical version. PostgreSQL 13 reached end of support in November 2025. See the current version for supported releases.
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

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
36.9. check_constraints  Home  36.11. collation_character_set_​applicability

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.