CODEWITHSUNDEEP
postgresql
jlfenaux
jlfenaux

Reputation: 3291

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 a "\copy from" ?

Thanks

Upvotes: 5

Views: 2755

Answers (2)

Scott Bailey
Scott Bailey

Reputation: 8306

Give it a try with PostgreSQL Loader instead.

Upvotes: 2

Frank Heikens
Frank Heikens

Reputation: 127367

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

Upvotes: 1

Related Questions