![]() | Postgres-XL 9.2 Documentation | |||
---|---|---|---|---|
Prev | Fast Backward | Chapter 35. The Information Schema | Fast Forward | Next |
Note: The following description applies both to Postgres-XL and PostgreSQL if not described explicitly.
The view schemata contains all schemas in the current database that are owned by a currently enabled role.
Table 35-37. 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 Postgres-XL |
default_character_set_schema | sql_identifier | Applies to a feature not available in Postgres-XL |
default_character_set_name | sql_identifier | Applies to a feature not available in Postgres-XL |
sql_path | character_data | Applies to a feature not available in Postgres-XL |