O'Reilly logo
  • Harisai Marisa thinks this is interesting:

Then add your new schema to the search path


Cover of PostgreSQL: Up and Running, 2nd Edition


if u dont have role name same as schema name , then u have to set searrch_path to schema name everytime to reflect changes in ur schema.