PostgreSQL

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

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

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`

36.9. check_constraints

36.11. collation_character_set_applicability