39.10. collations

39.10. `collations`
Prev	Up	Chapter 39. The Information Schema	Home	Next

39.10. `collations`

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

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

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
39.9. `check_constraints`	Home	39.11. `collation_character_set_applicability`