PostgreSQL: Documentation: 12: 36.10. collations

Documentation → PostgreSQL 12

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.

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`