Re: psql \copy

[Ron]

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 get

from 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.