Home>

After connecting to the database

select current_schema ();
When you execute the above command

current_schema

(1 line)

Is displayed and the schema name is not displayed

Why isn't it displayed?

search_path is set to $user
The username schema has also been created.

  • Answer # 1

    select current_user, current_database (), current_schema ();

    The schema is displayed by the above command.