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 <t...@sss.pgh.pa.us> wrote: > Jayadevan M <maymala.jayade...@gmail.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 >
