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