# 37.10. collations

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

#### **Table 37.8. `collations` Columns**

| <p>Column Type</p><p>Description</p>                                                                                                                                      |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <p><code>collation\_catalog</code> <code>sql\_identifier</code></p><p>Name of the database containing the collation (always the current database)</p>                     |
| <p><code>collation\_schema</code> <code>sql\_identifier</code></p><p>Name of the schema containing the collation</p>                                                      |
| <p><code>collation\_name</code> <code>sql\_identifier</code></p><p>Name of the default collation</p>                                                                      |
| <p><code>pad\_attribute</code> <code>character\_data</code></p><p>Always <code>NO PAD</code> (The alternative <code>PAD SPACE</code> is not supported by PostgreSQL.)</p> |