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