Select Code to Download

CREATE TABLE TableIndex
(
    table_date    date,
    table_id      integer
)

my ($dbh,$sth,$sql);

...
# insert the data into the new table
$sql = qq/INSERT INTO "$table_id" VALUES (?,?)/;
# now insert your data...etc