Import CSV directly via Postgres

Preparation

You need to have already created your table (yourtable) in postgres

Steps

1. save from Sheet Software to tab delimited text file including headers
2. encode in UTF without BOM
3. copy file on postgres server to /tmp
4. log on to postgres using

psql -d metasfresh

1. start import

copy migration_data.yourtable from '/tmp/yourfile.txt' with delimiter E'\t' CSV HEADER;