 --
 -- Compute/Set additional fields 
 --
+UPDATE public.refgene_hg19 SET txrange=int8range(txstart, txend);
+
 
 UPDATE public.refgene_hg19 SET variant_ids=array_agg(v.id)
 FROM public.variant_hg19 v

--
-- Command to import data from csv
--
COPY refgene_hg19 FROM '/tmp/hg19_db/refGene.txt' DELIMITER ',' CSV;




  CACHE 1;
ALTER TABLE public.refgene_hg19_id_seq
  OWNER TO annso;

ALTER TABLE public.refgene_hg19 ADD txrange int8range;
ALTER TABLE public.refgene_hg19 ADD id integer NOT NULL DEFAULT nextval('refgene_hg19_id_seq'::regclass);
ALTER TABLE public.refgene_hg19 ADD variant_ids integer[][];


--
