postgrep根据模式释放所有表锁

   select pg_cancel_backend(pid) from pg_locks where relation in (SELECT DISTINCT oid
FROM
    information_schema.tables t1,
    pg_class t2 
WHERE
    table_schema = ‘模式名' 
    AND t1."table_name" = t2.relname);