The documentation says:
The view schemata contains all schemas in the current database that
are owned by a currently enabled role.
( http://www.postgresql.org/docs/9.2/static/infoschema-schemata.html )
However it shows all schemas if the user is a superuser, regardless of
whether the schema is owned by the superuser.
Does the documentation need clarifying? I'd suggest something like:
The view schemata contains all schemas in the current database that
are owned by a currently enabled role, or all schemas if the currently
enabled role is a superuser.
Regards
Ian Lawrence Barwick
