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.