p393975269的博客

select datname,query,pid from pg_stat_activity where pid in (pid的值)　　　　查看锁的类型。select oid from pg_class where relname=‘表名’　　　　#注意pg_class不是全局，需要切换到相应的库里去查询。select pid from pg_locks where relation = oid的值。select pg_terminate_backend(pid) 　　　　释放锁。

win7下安装postgreSQL教程