Re: problems viewing information_schema.schemata

I did investigate this issue and the problem is pg_has_role function.

Take a look at information_schema.schemata definition below
SELECT (current_database ()) ::information_schema.sql_identifier AS
catalog_name
    , (n.nspname) ::information_schema.sql_identifier AS schema_name
    , (u.rolname) ::information_schema.sql_identifier AS schema_owner
    , (NULL::character VARYING) ::information_schema.sql_identifier AS
default_character_set_catalog
    , (NULL::character VARYING) ::information_schema.sql_identifier AS
default_character_set_schema
    , (NULL::character VARYING) ::information_schema.sql_identifier AS
default_character_set_name
    , (NULL::character VARYING) ::information_schema.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));


--
View this message in context:
http://postgresql.1045698.n5.nabble.com/problems-viewing-information-schema-schemata-tp4639500p4640939.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.