====== SQL ======

===== PGSQL =====
==== 删除所有的表 ====


<code copy Bash [enable_line_numbers="true"]>DO $$ DECLARE
    r RECORD;
BEGIN
    FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = current_schema()) LOOP
        EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(r.tablename) || ' CASCADE;';
    END LOOP;
END $$;</code>