​
Overview

The current_schema() is a session information function that returns the name of the first existing schema.

​
Syntax

There are two available syntax versions of current_schema() function: 
SELECT current_schema();
It will return NULL if none of the schemas from search_path exist

​
Example

The following example shows how to get the current schema name using this function 
SELECT current_schema();
The output from the above query can be as follows: 
+------------+
| f          |
+------------+
| public     |
+------------+