1

13693261870

2022-10-13 e9aa558bc6d3ae584d20ba089d6be878516de73a

 data/db_fn.sql

@@ -1,4 +1,7 @@
----------------------------------------------------------------------------------------------------- 递归查询
----------------------------------------------------------------------------------------------------- 1.查询连接数
show max_connections;
select count(1) from pg_stat_activity;
----------------------------------------------------------------------------------------------------- a.递归查询
--------------------------------------------------------- 查询菜单
select * from lf.sys_menu order by order_num;

@@ -26,9 +29,6 @@
  select a.* from lf.sys_dir a, rs b where a.pid=b.id
)
select * FROM rs order by order_num;
----------------------------------------------------------------------------------------------------- a.查询连接数
show max_connections;
select count(1) from pg_stat_activity;
----------------------------------------------------------------------------------------------------- b.查询表结构
select * from pg_tables;
select * from pg_class order by relnamespace;