ERROR: could not stat file “XX.csv”: Unknown error

by

You can work around this by piping the file through a program. For example I just used this to copy from a 24GB file on Windows 10 and PostgreSQL 11.

copy t(c,d) from program 'cmd /c "type x:\path\to\file.txt"' with (format text);

This copies the text file file.txt into the table t, columns c and d.

The trick here is to run cmd in a single command mode, with /c and telling it to type out the file in question.

More Related Contents:

  1. How to import CSV file data into a PostgreSQL table
  2. How to export table as CSV with headings on Postgresql?
  3. In PostgreSQL, how to insert data with COPY command?
  4. PostgreSQL: export resulting data from SQL query to Excel/CSV
  5. What to do with null values when modeling and normalizing?
  6. Postgres: INSERT if does not exist already
  7. postgres default timezone
  8. How to get the count of current month Sunday’s in psql?
  9. quick random row selection in Postgres
  10. Restore a postgres backup file using the command line?
  11. How to close idle connections in PostgreSQL automatically?
  12. postgresql – replace all instances of a string within text field
  13. Is it possible to have autoincrement number without it being an ID?
  14. PostgreSQL: Modify OWNER on all tables simultaneously in PostgreSQL
  15. pgadmin4 : postgresql application server could not be contacted.
  16. PostgreSQL error ‘Could not connect to server: No such file or directory’
  17. Insert if not exists, else return id in postgresql
  18. function returns multiple columns as a single column instead of multiple columns
  19. Sequences not affected by transactions?
  20. Postgres: check if array field contains value?
  21. Dynamic pivot query using PostgreSQL 9.3
  22. PostgreSQL ERROR: canceling statement due to conflict with recovery
  23. Change type of varchar field to integer: “cannot be cast automatically to type integer”
  24. Find Parent Recursively using Query
  25. Is there a way to disable updates/deletes but still allow triggers to perform them?
  26. PostgreSQL via SSH Tunnel
  27. How should I import data from CSV into a Postgres table using pgAdmin 3?
  28. PostgreSQL – set a default cell value according to another cell value
  29. What’s the difference between pg_table_size, pg_relation_size & pg_total_relation_size? (PostgreSQL)
  30. JPA and PostgreSQL with GenerationType.IDENTITY

Leave a Comment