postgresql 9 查看表锁

1.  查询

    SELECT pid FROM pg_stat_activity WHERE datname='数据库名'    SELECT pid FROM pg_stat_activity WHERE d