GP 锁表查询
摘要：01， 查询锁表情况 SQL> select * from gp_toolkit.gp_locks_on_relation WHERE lorrelname like '%wpp_cdefect_glass_f%'; 详细查询： SELECT pid,rolname, rsqname, grante
阅读全文
posted @
2020-03-20 16:22
kingle-l
阅读(3107)
推荐(0) 编辑
gp 日常使用脚本
摘要：--查询某schema下所有函数的属主 SELECT n.nspname AS "Schema",p.proname AS "Name",pg_catalog.pg_get_userbyid(p.proowner) AS "Owner" FROM pg_catalog.pg_proc p LEFT
阅读全文
posted @
2020-03-20 15:45
kingle-l
阅读(1041)
推荐(0) 编辑
