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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
