current_schema()

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:

Version 1

SELECT current_schema();

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     |
+------------+