![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
postgresql
p393975269
甜蜜大橙
展开
-
postgres查看是否锁表并释放
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) 释放锁。原创 2023-10-21 20:48:02 · 356 阅读 · 0 评论 -
win7下安装postgreSQL教程
win7下安装postgreSQL教程原创 2023-02-21 15:11:28 · 1466 阅读 · 0 评论