人大金仓更改默认模式

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'