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

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

  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[][];


--
