PostgreSQL 锁表 1. 拼接解锁语句 select 'select pg_cancel_backend(' || pid || ');' from ( select a.oid, b.pid, a.relname from pg_class a left join pg_locks b on a.oid = b.relation where a.relname like '%表名%') t where pid is not null; 2. 执行上句查询语句 -- example select pg_cancel_backend(992015);