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

Responses

• Privileges for INFORMATION_SCHEMA.SCHEMATA (was Re: Small clarification in "34.41. schemata") at 2013-01-10 01:56:35 from Tom Lane

pgsql-docs by date

Next:	From: Tom Lane	Date: 2013-01-10 01:56:35
	Subject: Privileges for INFORMATION_SCHEMA.SCHEMATA (was Re: Small clarification in "34.41. schemata")
Previous:	From: Bruce Momjian	Date: 2013-01-09 22:10:56
	Subject: Re: PostgreSQL docs in ePub format

pgsql-hackers by date

Next:	From: Josh Berkus	Date: 2013-01-10 00:38:36
	Subject: Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL
Previous:	From: Simon Riggs	Date: 2013-01-09 23:40:28
	Subject: Re: Index build temp files