Holger Jakobs <holger(at)jakobs(dot)com> writes:
> Oracle's behaviour of saving all non-failing records while discarding
> all failing records is not directly possible with PostgreSQL, because
> the sense of a transaction is all-or-nothing.
There are external tools that can emulate row-at-a-time loading,
such as pgloader [1]. I'm not sure what sort of speed penalty
you pay for that, but I imagine it's not trivial.
regards, tom lane
[1] https://pgloader.io