how do I capture conflicting rows - Mailing list pgsql-admin

From Nikhil Ingale
Subject how do I capture conflicting rows
Date
Msg-id CALXkTpx3iLuGRx1_4N6GJ85ptoW4n4XSdh3ChJLE-hrFGC982g@mail.gmail.com
Whole thread Raw
Responses Re: how do I capture conflicting rows
Re: how do I capture conflicting rows
Re: how do I capture conflicting rows
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Nikhil Ingale
Date:
Subject: Re: Find out the indexed columns
Next
From: Ron
Date:
Subject: Re: how do I capture conflicting rows