Name: | schemata |
Owner: | postgres |
Has rules: | |
Has Triggers: | |
Comment: |
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 |
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