人大金仓更改默认模式
ALTER database xwdh SET search_path TO “$USER”, xwdh, my_schema;
jdbc:kingbase8://192.168.19.240:54321/xwdh?currentSchema=xwdh
解决系统表冲突
alter database xwdh set search_path to "$user", govengine, public, sys, sys_catalog, pg_catalog;
select sys_reload_conf()
SELECT * FROM sys_user
修改配置的形式解决无需加模式名
kingbase.conf
search_path = '"$USER", PUBLIC,SYS_CATALOG'