2019/7/13孙小北
PgSQL常用SQL语句汇总
(1)强制关闭链接,删除数据库select pg_terminate_backend(pg_stat_activity.pid) from pg_stat_activity where datname='testdb' and pid<>pg_backend_pid();drop database testdb;(2)筛选某列,逗号拼接:string_agg(列名,',') select string_agg(bs_org_id,',') as bs_org_ids from bs_org where par_org_id ...