Cloudfront Logs

Creating postgres db table

create table req (logdate varchar(4096), logtime varchar(4096), edge varchar(40), bytes int, cip varchar(50), method varchar(50), host varchar(4096), uri varchar(4096), status varchar(20), creferrer varchar(4096), useragent varchar(4096), cs_uri_query varchar(4096), cookie varchar(4096), x_edge_result_type varchar(4096), x_edge_request_id varchar(4096), x_host_header varchar(4096), protocol varchar(4096), cs_bytes varchar(4096));