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 

 

 

posted @ 2019-11-13 11:16  陈_某某  阅读(2108)  评论(1编辑  收藏  举报