```psql -- 清空表 DO $$ DECLARE r RECORD; begin FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = 'public') LOOP EXECUTE 'DROP TABLE IF EXISTS public.' || quote_ident(r.tablename) || ' CASCADE'; END LOOP; END $$;
``psql
-- 清空表
DO $$ DECLARE
r RECORD;
begin
FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = 'public') LOOP
EXECUTE 'DROP TABLE IF EXISTS public.' || quote_ident(r.tablename) || ' CASCADE';
END LOOP;
END $$;
-- 清空函数
DO $$
DECLARE
rec record;
sql text;
BEGIN
FOR rec IN
SELECT ns.nspname || '.' || proname || '(' || oidvectortypes(proargtypes) || ')' AS func_name
FROM pg_proc
INNER JOIN pg_namespace ns ON (pg_proc.pronamespace = ns.oid)
WHERE ns.nspname NOT IN ('pg_catalog', 'information_schema')
LOOP
sql := 'DROP FUNCTION ' || rec.func_name || ' CASCADE;';
EXECUTE sql;
END LOOP;
END;
$$;
``
This project is an open-source component of i18n.site ⋅ Internationalization Solution.
* i18 : MarkDown Command Line Translation Tool
The translation perfectly maintains the Markdown format.
It recognizes file changes and only translates the modified files.
The translated Markdown content is editable; if you modify the original text and translate it again, manually edited translations will not be overwritten (as long as the original text has not been changed).
* i18n.site : MarkDown Multi-language Static Site Generator
Optimized for a better reading experience
本项目为 i18n.site ⋅ 国际化解决方案 的开源组件。
翻译能够完美保持 Markdown 的格式。能识别文件的修改，仅翻译有变动的文件。
Markdown 翻译内容可编辑；如果你修改原文并再次机器翻译，手动修改过的翻译不会被覆盖（如果这段原文没有被修改）。
* i18n.site : MarkDown多语言静态站点生成器 为阅读体验而优化。