Postgres Query to combine all other tables as one

create table fda_combine_data as (select fs1.isr,fs1.age,fs1.age_cod,fs1.gndr_cod,fs1.wt,fs1.wt_cod,fs2.role_cod,fs2.drugname,
fs2.route,fs2.dose_vbm, fs3.indi_pt,fs4.outc_cod,fs5.pt,fs1.occp_cod,fs1."CASE",fs1.i_f_cod,
fs1.foll_seq,fs1.image,fs1.event_dt,fs1.mfr_dt,fs1.fda_dt,fs1.rept_cod,fs1.mfr_num,fs1.mfr_sndr,
fs1.e_sub,fs1.rept_dt,fs1.death_dt,fs1.to_mfr,fs1.confid,fs1.reporter_country,fs2.drug_seq,fs2.val_vbm,
fs2.dechal,fs2.rechal,fs2.lot_num,fs2.exp_dt,fs2.nda_num,fs6.rpsr_cod,
fs7.start_dt,fs7.end_dt,fs7.dur,fs7.dur_cod from fda_sheet1 fs1
LEFT outer JOIN fda_sheet2 fs2 on (fs1.isr=fs2.isr)
LEFT outer JOIN fda_sheet3 fs3 on (fs1.isr=fs3.isr)
LEFT outer JOIN fda_sheet4 fs4 on (fs1.isr=fs4.isr)
LEFT outer JOIN fda_sheet5 fs5 on (fs1.isr=fs5.isr)
LEFT outer JOIN fda_sheet6 fs6 on (fs1.isr=fs6.isr)
LEFT outer JOIN fda_sheet7 fs7 on (fs1.isr=fs7.isr) );


create index fda_combine_data_isr
on fda_combine_data
using btree(isr);

create index fda_combine_data_age
on fda_combine_data
using btree(age);

create index fda_combine_data_age_cod
on fda_combine_data
using btree(age_cod);

create index fda_combine_data_gndr_cod
on fda_combine_data
using btree(gndr_cod);

create index fda_combine_data_wt
on fda_combine_data
using btree(wt);

create index fda_combine_data_wt_cod
on fda_combine_data
using btree(wt_cod);

create index fda_combine_data_role_cod
on fda_combine_data
using btree(role_cod);

create index fda_combine_data_drugname
on fda_combine_data
using btree(drugname);


create index fda_combine_data_route
on fda_combine_data
using btree(route);


create index fda_combine_data_dose_vbm
on fda_combine_data
using btree(dose_vbm);

create index fda_combine_data_indi_pt
on fda_combine_data
using btree(indi_pt);


create index fda_combine_data_pt
on fda_combine_data
using btree(pt);

create index fda_combine_data_occp_cod
on fda_combine_data
using btree(occp_cod);

create index fda_combine_data_outc_cod
on fda_combine_data
using btree(outc_cod);



create index fda_combine_data_case
on fda_combine_data
using btree("CASE");

create index fda_combine_data_i_f_cod
on fda_combine_data
using btree(i_f_cod);