diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2013-09-09 22:25:37 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2013-09-09 22:25:37 -0400 |
| commit | b34f8f409bec4921d260ac84668917f5fff04319 (patch) | |
| tree | ef325d32b353ca3f88c50d9d6746acd4024a140c /doc/src | |
| parent | 71901ab6daaad65c0168c05e016e4208efe5b71a (diff) | |
| download | postgresql-b34f8f409bec4921d260ac84668917f5fff04319.tar.gz postgresql-b34f8f409bec4921d260ac84668917f5fff04319.zip | |
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.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/information_schema.sgml | 5 |
1 files changed, 3 insertions, 2 deletions
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> |