aggregate-fastqc.sql

drop table if exists ea1.fastqc_summary;
create table ea1.fastqc_summary (
fileid varchar,
module varchar,
status varchar
);
drop table if exists ea1.fastqc_details;
create table ea1.fastqc_details (
id serial primary key,
fileid varchar,
module varchar,
col1 varchar,
ocols varchar
);

copy ea1.fastqc_summary from 'fastqc_summary.txt';
copy ea1.fastqc_details (fileid, module, col1, ocols) from 'fastqc_details.txt';