PostgreSQL 8.1.23 Documentation | ||||
---|---|---|---|---|
Prev | Fast Backward | Chapter 31. The Information Schema | Fast Forward | Next |
The view schemata contains all schemas in the current database that are owned by the current user.
Table 31-25. 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 |