CODE EXAMPLE FOR SQL

postgres automatic partioning a table

-- Finally copy the data to our new partitioned table
insert into myTable (forDate, key2, value) select * from myTable_old;

-- And get rid of the old table
drop table myTable_old;