   CACHE 1;
 ALTER TABLE public.refgene_hg19_id_seq
   OWNER TO annso;
-  
-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[][]
+
+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[][];
 
 
 --

  name2 character varying(255) NOT NULL,
  cdsstartstat cdsstat NOT NULL,
  cdsendstat cdsstat NOT NULL,
  exonframes text NOT NULL,
  txrange int8range
)
WITH (
  OIDS=FALSE

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



