PostgreSQL/Postgre SQL/current schema

current_schemas("false")

postgres=# select current_schemas("false");
 current_schemas
-----------------
 {public}
(1 row)
postgres=#
postgres=#

Name of current schema

postgres=#
postgres=# -- name of current schema
postgres=# select current_schema();
 current_schema
----------------
 public
(1 row)
postgres=#
postgres=#

Names of schemas in search path optionally including implicit schemas

postgres=#
postgres=# -- names of schemas in search path optionally including implicit schemas
postgres=# select current_schemas("true");
   current_schemas
---------------------
 {pg_catalog,public}
(1 row)
postgres=#