#!/bin/sh

wget ftp://ftp.ncbi.nih.gov/pub/HomoloGene/current/homologene.data;

< homologene.data psql -c "
  drop table if exists my_homologene_data;
  create table         my_homologene_data (
    homologene_group_id  integer , 
    tax_id               integer , 
    geneid               integer , 
    symbol               text    , 
    protein_gi           integer , 
    protein_accession    text     
 );
 copy my_homologene_data from stdin csv delimiter E'\t';
";

echo "select count(*) from my_homologene_data" | psql;