how do I capture conflicting rows

[Nikhil Ingale <niks.bgm@xxxxxxxxx>]

Hi All,

The following query inserts the rows by ignoring the rows that has conflicts.

INSERT INTO test (id,name,age,branch) SELECT * FROM student ON CONFLICT DO NOTHING;

How do I capture the conflicting records to a file while non conflicting records are inserted to the table?

Regards,
Nikhil Ingale