Pgsql 针对表找不见的问题，执行 ALTER DATABASE eamic SET search_path TO public, mic_admin, mic00001,mic00002,mic00003;

标题 eamic 是数据库名，对应下图的postgres,       public，mic00001,是模式名称

 

 

 

CREATE USER mic00002 WITH PASSWORD 'matrix11'; -- 创建用户
grant usage on schema mic_admin,mic00002 to mic00002; -- 授权访问模式
grant USAGE, SELECT on all sequences in schema mic_admin,mic00002 to mic00002;
grant TRUNCATE, SELECT, INSERT, UPDATE, DELETE on all tables in schema mic_admin,mic00002 to mic00002; -- 授权CURD
ALTER DATABASE eamic SET search_path TO public, mic_admin, mic00001,mic00002,mic00003;