Holger Jakobs <holger@xxxxxxxxxx> 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
