ALTER DATABASE my_db SET search_path TO "$user",public,other_schema;

SET search_path "$user",public,other_schema;

RESET search_path;