Returns the name of the schema at the front of the search path. This schema will be used for any tables or other named objects that are created without specifying a target schema.
Syntax
Note
This is a leader-node function. This function returns an error if it references a user-created table, an STL or STV system table, or an SVV or SVL system view.
current_schema()Return type
CURRENT_SCHEMA returns a CHAR or VARCHAR string.
Examples
The following query returns the current schema:
select current_schema();
current_schema
----------------
public
(1 row)