Skip site navigation (1) Skip section navigation (2)

Small clarification in "34.41. schemata"

From: Ian Lawrence Barwick <barwick(at)gmail(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: Small clarification in "34.41. schemata"
Date: 2013-01-10 00:35:10
Message-ID: CAB8KJ=g317u8GVyoi+E8cByOGVa+iNVsriTgC+XFA-k2wqpCTA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackers
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

pgsql-docs by date

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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group