The view schemata
contains all schemas in the
current database that are owned by a currently enabled role.
Table 32.28. schemata
Columns
Name | Data Type | Description |
---|---|---|
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 |