赞
踩
- select c.pid,a.relname,c.* from
- pg_class a,
- pg_locks b,
- pg_stat_activity c
- where b.relation = a.oid
- and b.pid = c.pid
- and a.relname='table_name';--表名
-
- select pg_terminate_backend(上面pid);
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。