CURRENT_SCHEMAS()

Return all schemas in the search path (or a null value if the search path is empty).
CURRENT_SCHEMAS()
For example:
premdb=# set search_path to public, sys, bobr;
SET
premdb=# select current_schemas();
current_schemas
-----------------
public,sys,bobr
(1 row)

See also CURRENT_SCHEMA.