pickup_capacities.plpgsql

DO $$
DECLARE
  d1 pickupcapacities.deliverydate%TYPE;
  d2 pickupcapacities.deliverydate%TYPE;
  day pickupcapacities.dayofweek%TYPE;
BEGIN
  d1 := '11-05-2017';
  d2 := '12-31-2017';

  LOOP
    
    day := substring(to_char(d1, 'day') from 1 for 3);

    INSERT INTO pickupcapacities (zoneid, deliverydate, capacity, filled, resetdate, dayofweek)
    VALUES ('CPU', d1, 5000, 0, current_date, day);
    
    d1 := d1 + 1;

    EXIT WHEN d1 > d2;
    
  END LOOP;
END$$;