【无标题】查询PG某个模式下的各个表记录数

最新推荐文章于 2024-06-27 09:40:58 发布

岁月静好8285

最新推荐文章于 2024-06-27 09:40:58 发布

阅读量1.3k

点赞数 1

文章标签： servlet java javascript

本文链接：https://blog.csdn.net/zhanghongxia8285/article/details/126590197

版权

create function
cnt_rows(schema text, tablename text) returns integer
as
$body$
declare
result integer;
query varchar;
begin
query := 'SELECT count(1) FROM ' || schema || '.' || tablename;
execute query into result;
return result;
end;
$body$
language plpgsql;

select * from (select
cnt_rows(table_schema, table_name),information_schema.tables."table_name"
from information_schema.tables
where table_schema='schema_name'
and table_type='BASE TABLE') as s;