bulk insert unique contraint - Mailing list pgsql-general

From Janek Sendrowski
Subject bulk insert unique contraint
Date
Msg-id trinity-4ad2fe0e-47ed-4abe-87c3-28b1b69319f3-1388412840473@3capp-webde-bs21
Whole thread Raw
Responses Re: bulk insert unique contraint
List pgsql-general
Hi,
 
I want to insert data in my table and I want to insert the rows, which don't violates the unique contraint of my id.
I'musing a 64bit hash for my it. 
If I do one insert statement, which inserts many rows it doesn't do anything if one row violates the unique contraint.
Is there a faster way than using multiple insert statements?
 
Janek


pgsql-general by date:

Previous
From: Tim Kane
Date:
Subject: Re: ON_ERROR_EXIT and interactive mode (or, how to force interactive mode off)
Next
From: Andy Colson
Date:
Subject: Re: bulk insert unique contraint