Re: search_path and current_schema

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com> 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
>