CURRENT_SCHEMA

PostgreSQL

CURRENT_SCHEMA()

Example

CREATE SCHEMA tech;
SET search_path TO tech;
SELECT CURRENT_SCHEMA;

Output

  current_schema
------------------
 tech
(1 row)

Explanation

In the example, a new schema named ‘tech’ is created. After that, the search path is set to ‘tech’, effectively making it the current schema. The CURRENT_SCHEMA function is then used to return the name of the current schema, which is ‘tech’.

Oracle

CURRENT_SCHEMA

Example

SELECT CURRENT_SCHEMA FROM dual;

Output

'HR'

Explanation

The above SQL code retrieves the current schema in an Oracle database. The output ‘HR’ indicates that the current schema in use is ‘HR’.