# 37.46. schemata

The view `schemata` contains all schemas in the current database that the current user has access to (by way of being the owner or having some privilege).

#### **Table 37.44. `schemata` Columns**

| <p>Column Type</p><p>Description</p>                                                                                                                    |
| ------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <p><code>catalog\_name</code> <code>sql\_identifier</code></p><p>Name of the database that the schema is contained in (always the current database)</p> |
| <p><code>schema\_name</code> <code>sql\_identifier</code></p><p>Name of the schema</p>                                                                  |
| <p><code>schema\_owner</code> <code>sql\_identifier</code></p><p>Name of the owner of the schema</p>                                                    |
| <p><code>default\_character\_set\_catalog</code> <code>sql\_identifier</code></p><p>Applies to a feature not available in PostgreSQL</p>                |
| <p><code>default\_character\_set\_schema</code> <code>sql\_identifier</code></p><p>Applies to a feature not available in PostgreSQL</p>                 |
| <p><code>default\_character\_set\_name</code> <code>sql\_identifier</code></p><p>Applies to a feature not available in PostgreSQL</p>                   |
| <p><code>sql\_path</code> <code>character\_data</code></p><p>Applies to a feature not available in PostgreSQL</p>                                       |