The schemata view provides information about all schemas accessible to the current user.
| Column name | Data type | Description |
|---|---|---|
catalog_name |
sql_identifier |
The name of the current database that contains the schema. |
schema_name |
sql_identifier |
The name of the schema. |
schema_owner |
sql_identifier |
The name of the schema owner. |
default_character_set_catalog |
sql_identifier |
Applies to a feature that is not available in PostgreSQL. |
default_character_set_schema |
sql_identifier |
Applies to a feature that is not available in PostgreSQL. |
default_character_set_name |
sql_identifier |
Applies to a feature that is not available in PostgreSQL. |
sql_path |
character_data |
Applies to a feature that is not available in PostgreSQL. |