A PLPGSQL script to truncate all tables in a given list of schemas

truncate all tables in a schema.md

-- Usage: SELECT truncate_all_tables_in_schemas(ARRAY['schema1', 'schema2', 'schema3']);
CREATE OR REPLACE FUNCTION truncate_all_tables_in_schemas(schema_names text[]) RETURNS void AS $$
DECLARE 
   schema_name text;
   table_name text; 
BEGIN 
   FOREACH schema_name IN ARRAY schema_names
   LOOP
      FOR table_name IN (SELECT tablename FROM pg_tables WHERE schemaname = schema_name) 
      LOOP 
         EXECUTE 'TRUNCATE TABLE ' || schema_name || '.' || table_name; 
      END LOOP; 
   END LOOP;
END $$ LANGUAGE plpgsql;