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 wrote:
> Jayadevan M writes:
> > I thought current_schemas and search_path will return the same set of
> > schemas (exce
Jayadevan M 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 us
Hi,
I was trying out schema settings and related functions. PostgreSQL version
is 9.3
[postgres@MyCentOS 9.3]$ psql
psql (9.3.0)
Type "help" for help.
postgres=# show search_path;
search_path
"$user",public
(1 row)
postgres=# select current_schemas(true);
current_schemas
