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 35-39. schemata Columns
|catalog_name||sql_identifier||Name of the database that the schema is contained in (always the current database)|
|schema_name||sql_identifier||Name of the schema|
|schema_owner||sql_identifier||Name of the owner of the schema|
|default_character_set_catalog||sql_identifier||Applies to a feature not available in PostgreSQL|
|default_character_set_schema||sql_identifier||Applies to a feature not available in PostgreSQL|
|default_character_set_name||sql_identifier||Applies to a feature not available in PostgreSQL|
|sql_path||character_data||Applies to a feature not available in PostgreSQL|
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.