13.4. CURRENT_SCHEMA

Current schema of the connection

TypeVARCHAR(63)

Syntax

CURRENT_SCHEMA

The CURRENT_SCHEMA context variable reports the first schema from the schema search path that exists.

The value of CURRENT_SCHEMA can change without changing the search path. This can happen if a schema is created (if it was listed in the search path before the previously reported schema), or if the previously reported schema was dropped.

See alsoSection 16.4.1, “SET SEARCH_PATH”