Help for this page

Select Code to Download

Select or download this

# for instance, a program producing tab-delimited output:
perl my_tsv.pl | psql -d dbname -c "copy mytable from stdin csv delimi
+ter E'\t'"

Select or download this

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