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(dot)klaver(at)aklaver(dot)com