![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
PG数据库
文章平均质量分 54
minna_D
这个作者很懒,什么都没留下…
展开
-
PG常用SQL
一、查看当前数据库连接SELECT pg_stat_get_backend_pid(s.backendid) AS procpid, pg_stat_get_backend_activity(s.backendid) AS current_query FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s;原创 2015-01-09 14:36:38 · 1211 阅读 · 0 评论 -
常见SQL细节
博客主页:http://blog.csdn.net/minna_d1. 关于count及sumcount结果用不null,sum可能会出现null的情况hotel=> select count(0), count(1), count(*) , count(id), sum(1), sum(id) from info_op_log where id = -1; count原创 2015-01-22 21:55:11 · 627 阅读 · 0 评论