PostgreSQL/Postgre SQL/current schema

current_schemas("false")

   <source lang="sql">

postgres=# select current_schemas("false");

current_schemas

---

{public}

(1 row) postgres=# postgres=#

      </source>
   
  

Name of current schema

   <source lang="sql">

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

current_schema

---

public

(1 row) postgres=# postgres=#

      </source>
   
  

Names of schemas in search path optionally including implicit schemas

   <source lang="sql">

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=#

      </source>