DROP EXTENSION IF EXISTS postgis CASCADE;

DO $$
DECLARE
    r RECORD;
BEGIN
    FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = 'public') LOOP
        EXECUTE 'DROP TABLE IF EXISTS "' || r.tablename || '" CASCADE;';
    END LOOP;
END $$;

-- For default uuid column
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

-- For citext caseinsensitive column
CREATE EXTENSION IF NOT EXISTS citext;


CREATE EXTENSION IF NOT EXISTS postgis;
