pg_partition_5.sql

CREATE OR REPLACE FUNCTION run_on_partitions(TEXT, TEXT)
  RETURNS INTEGER AS $$ DECLARE partition   RECORD;
                                tablename   TEXT = $1;
                                sql         TEXT = $2;
                                sqlReplaced TEXT;
BEGIN tablename := tablename || '%p';
  FOR partition IN SELECT relname :: TEXT AS rel
                   FROM pg_class
                   WHERE relname :: TEXT LIKE tablename AND relkind = 't'
                   ORDER BY relname LOOP sqlReplaced := replace(sql, '', partition.rel);
    RAISE NOTICE 'Executing: %', sqlReplaced;
    EXECUTE sqlReplaced;
  END LOOP;
  RETURN 1;
END; $$ LANGUAGE plpgsql;