Skip to content
DBCode

CURRENT_PATH

Example

Section titled “Example”
SELECT CURRENT_PATH;

Output

Section titled “Output”
"$user",public

Explanation

Section titled “Explanation”

The CURRENT_PATH function in PostgreSQL returns the current search path, which is a list of schemas that the system uses to locate tables, views, functions, and other database objects. In the returning example "$user", public, the search path indicates that the system will first look for objects in the user’s schema (represented by the $user), and then in the public schema.