PostgreSQL和Kingbase中设置当前模式

会话级别设置:

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