Wonach suchst Du?
What are you looking for?

Import CSV directly via Postgres


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


  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;

View source file on GitHub.com