Re: search_path and current_schema

[Jayadevan M <maymala.jayadevan@xxxxxxxxx>]

OK. When I logged in as a user who had access to the schema, the output from current_schemas and search_path were matching.
Thanks.

On Sun, Oct 27, 2013 at 9:55 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

Jayadevan M <maymala.jayadevan@xxxxxxxxx> writes:
> I thought current_schemas and search_path will return the same set of
> schemas (except that current_schema will show pg_catalog also, if we use
> true). Shouldn't mynewschema appear in the output of select
> current_schemas(true)?

Only if it actually exists (and you have usage privilege on it).  See
the description of the search_path variable: nonexistent entries are
silently ignored.

Possibly this behavior should be documented under current_schemas()
as well as under the GUC variable.

                        regards, tom lane