You might want to investigate pg_bulkload for this activity. On 4/24/20 10:55 AM, Steve Clark wrote:
Hello,I am using psql to copy data extracted from an InfluxDB in csv format into postgresql. I have a key field on the time field which I have defined as a bigint since the time I getfrom InfluxDB is an epoch time.My question is does psql abort the copy if it hits a duplicate key, or does it keep processing?
-- Angular momentum makes the world go 'round.