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)

CURRENT_SCHEMAS() ​