# or if the data is in a tsv file already: < data.tsv psql -d dbname -c "copy mytable from stdin csv delimiter E'\t'"