This page in other versions: 9.0 / 9.1 / 9.2 / 9.3 / 9.4  |  Development versions: devel  |  Unsupported versions: 7.4 / 8.0 / 8.1 / 8.2 / 8.3 / 8.4

32.27. schemata

The view schemata contains all schemas in the current database that are owned by the current user.

Table 32-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
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group