1、批量删除指定库的sql语句
DO $$
DECLARE names CURSOR FOR
select * from pg_tables where schemaname='zfd_api' limit 500 ;
BEGIN
FOR stmt IN names LOOP
EXECUTE 'DROP TABLE IF EXISTS zfd_api.'|| quote_ident(stmt.tablename) || ' CASCADE;';
END LOOP;
END;$$;
2、进入数据库
psql -U pgsql -d zfd_datacenter -h 127.0.0.1 -p 5433
3、查看表达小
--查看表大小
select pg_relation_size('zfd_sys.sys_call_third_api_log_t');
--查看表占用多大空间单位为M
select pg_size_pretty(pg_relation_size('public.sys_record_request_t'));