On 3/1/25 07:18, me nefcanto wrote:
Hello
All of these scenarios are such that data sanitation is difficult if not
possible before doing the bulk operation (copy).
I realized that when we specify `on_error ignore` it just handles a
handful of errors. I thought this was a bug and sent an email to the
pgsql-bugs maling list. But they said it's the intended behavior.
Take a look at:
http://ossc-db.github.io/pg_bulkload/index.html
and
https://pgloader.io/
They may be able to meet your needs.
Regards
Saeed
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx