Dealing with errors during a copy from

I've to import a file from an external source to a postgresql table. I tried to do it with \copy from , but I keep getting errors (additional columns) in the middle of the file.

Is there a way to tell postgresql to ignore lines containing errors during开发者_JAVA百科 a "\copy from" ?

Thanks

---

Give it a try with PostgreSQL Loader instead.

---

No. All data is correct or there is no data at all, those are the two options you have in PostgreSQL.