会话级别设置：
SHOW search_path;
SET search_path TO “$user”, public, my_schema;
SET search_path TO my_schema;
数据库级设置（跨会话）：
ALTER database XXX SET search_path TO “$USER”, public, my_schema;
JDBC:
URL： localhost:5432/mydatabase?currentSchema=myschema
原文：https://www.cnblogs.com/cjkcss/p/11847601.html