Work with errors while copying from

Question

I need to import a file from an external source into a postgresql table. I tried to do this with \ copy, but I keep getting errors (extra columns) in the middle of the file.

Is there a way to tell postgresql to ignore lines containing errors during "\ copy from"?

thank

Answer 1

Try instead of PostgreSQL Loader .

Answer 2

No. All data is correct or no data, these are two options that you have in PostgreSQL.