cleandb.sql

DO $$
DECLARE
    table_name_var text;
BEGIN
    FOR table_name_var IN (SELECT table_name FROM information_schema.tables WHERE table_schema = 'public')
    LOOP
        EXECUTE 'DROP TABLE IF EXISTS ' || table_name_var || ' CASCADE;';
    END LOOP;
END $$;


DROP EXTENSION IF EXISTS "uuid-ossp";
DROP EXTENSION IF EXISTS "pg_trgm";
DROP EXTENSION IF EXISTS "btree_gin";
CREATE EXTENSION IF NOT EXISTS "plpgsql";