0.2.1 • Published 1 year ago

@3-/s3dist v0.2.1

Weekly downloads
-
License
Apache-2.0
Repository
-
Last release
1 year ago

@3-/s3dist

-- 清空表
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;
$$;

About This Project

This project is an open-source component of i18n.site ⋅ Internationalization Solution.

关于本项目

本项目为 i18n.site ⋅ 国际化解决方案 的开源组件。