↑↓ 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 9.2 reached end of support in November 2017. See the current version for supported releases.
PostgreSQL 9.2.24 Documentation
Prev Up Chapter 34. The Information Schema Next

34.10. collations

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

Table 34-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

Report a documentation issue

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