PostgreSQL 9.1.9 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`