CURRENT_SCHEMA

CURRENT_SCHEMA returns the name of the current schema.

Cross reference to SET

Syntax

CURRENT_SCHEMA()

Examples

QATESTDB=> SELECT CURRENT_SCHEMA();

current_schema

----------------

public

(1 row)