metafresh logo and link to homepage

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;

Zur Quelldatei auf