https://blog.csdn.net/weixin_44789861/article/details/117854621
create user glib password 'cloudscape';
create role glib;
alter user system password 'cloudscape';
ALTER SCHEMA "fx" OWNER TO "username";
查看当前模式
select current_schema;
修改角色的搜索路径
alter role finona set search_path='finance';
创建用户专享的schema
CREATE SCHEMA sharedschema AUTHORIZATION scarlett;
用户模式权限
grant all on all tables in schema "CLOUDSCAPE_GLIB" to cloudscape_glib;
//查询连接情况 select datname,pid,application_name,state from pg_stat_activity;
//释放空闲连接 select pg_terminate_backend(1472) from pg_stat_activity where state='idle';
知识点:https://blog.csdn.net/weixin_41551276/article/details/119648172