Load data from csv file

[smarwei]

I wanted to use "copy" to copy data from a csv file to a table.
The postgresql-simple docs do not mention copying from/to a file though. (only stdin)
I tried it nevertheless, and it actually works (all data is loaded into the table), but the copy function gives me an error:
QueryError {qeMessage = "Database.PostgreSQL.Simple.Copy.copy_ CommandOk", [...]

Is it just not intended to load directly from files or is there another way?

[cimmanon]

How are you copying from a file? This worked for me in older versions:

catch
	(
		-- IO ()
		PG.copy_ c "COPY table_name FROM STDIN (FORMAT CSV, HEADER 1)" >>
		-- IO ()
		(PG.putCopyData c =<< BS.readFile f) >>
		-- IO Int64
		Right <$> PG.putCopyEnd c
		)
	(\(_ :: SomeException) -> return $ Left "Invalid CSV format")

[smarwei]

i just used

PG.copy_ c "COPY table_name (col_1, col_2, col_n) FROM '/path/to/file.csv' WITH (format 'csv', QUOTE '"', DELIMITER '|', escape '\', ENCODING 'UTF-8' );"

That's because I didn't think it was necessary to read the file first, since I don't need it for anything other than dumping it to the database.
I would also load csv files up to 10GB in size and thought it might be faster to let Postgres handle that.