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 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs