From b34f8f409bec4921d260ac84668917f5fff04319 Mon Sep 17 00:00:00 2001
From: Peter Eisentraut <peter_e@gmx.net>
Date: Mon, 9 Sep 2013 22:25:37 -0400
Subject: Show schemas in information_schema.schemata that the current has
 access to

Before, it would only show schemas that the current user owns.  Per
discussion, the new behavior is more useful and consistent for PostgreSQL.
---
 doc/src/sgml/information_schema.sgml | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/information_schema.sgml b/doc/src/sgml/information_schema.sgml
index 3ac555dad37..22e17bb5e69 100644
--- a/doc/src/sgml/information_schema.sgml
+++ b/doc/src/sgml/information_schema.sgml
@@ -4547,8 +4547,9 @@ ORDER BY c.ordinal_position;
   <title><literal>schemata</literal></title>
 
   <para>
-   The view <literal>schemata</literal> contains all schemas in the
-   current database that are owned by a currently enabled role.
+   The view <literal>schemata</literal> contains all schemas in the current
+   database that the current user has access to (by way of being the owner or
+   having some privilege).
   </para>
 
   <table>
-- 
cgit v1.2.3