CURRENT_SCHEMA

6min

Overview
The CURRENT_SCHEMA() function returns the name of the first existing schema.
It will return NULL if none of the schemas from search_path exist. 
Syntax
CURRENT_SCHEMA() function has the following syntax:
Syntax
|
SELECT CURRENT_SCHEMA();
SELECT CURRENT_SCHEMA();
﻿
Another method is to omit the parenthesis from the above syntax.
Another option
|
SELECT CURRENT_SCHEMA;
SELECT CURRENT_SCHEMA;
﻿
It does not require any argument to operate.
Example
The following example shows how to get the current schema name using CURRENT_SCHEMA() function.
Current schema
|
SELECT CURRENT_SCHEMA();
SELECT CURRENT_SCHEMA();
﻿
The final result will display the schema that you currently use:
Output
|
+------------+
| f          |
+------------+
| public     |
+------------+
+------------+
| f          |
+------------+
| public     |
+------------+
﻿
﻿

Updated 31 Aug 2023

Did this page help you?

TABLE OF CONTENTS

Overview

Syntax

Example