Properties

Name: schemata 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

Name Type Length
  catalog_name  sql_identifier  -1 
  schema_name  sql_identifier  -1 
  schema_owner  sql_identifier  -1 
  default_character_set_catalog  sql_identifier  -1 
  default_character_set_schema  sql_identifier  -1 
  default_character_set_name  sql_identifier  -1 
  sql_path  character_data  -1 
Total: 7 column(s)

SQL


CREATE VIEW schemata AS
    SELECT (current_database())::sql_identifier AS catalog_name, (n.nspname)::sql_identifier AS schema_name, (u.rolname)::sql_identifier AS schema_owner, (NULL::character varying)::sql_identifier AS default_character_set_catalog, (NULL::character varying)::sql_identifier AS default_character_set_schema, (NULL::character varying)::sql_identifier AS default_character_set_name, (NULL::character varying)::character_data AS sql_path FROM pg_namespace n, pg_authid u WHERE ((n.nspowner = u.oid) AND pg_has_role(n.nspowner, 'USAGE'::text));


ALTER TABLE information_schema.schemata OWNER TO postgres;

See Also

List of views