Re: psql \copy - Mailing list pgsql-general

From David G. Johnston
Subject Re: psql \copy
Date
Msg-id CAKFQuwav9XoQuxZ8pruw=ODDmWGYrrUUOgwQ1S9jvUbgigLAxA@mail.gmail.com
Whole thread Raw
In response to psql \copy  (Steve Clark <steve.clark@netwolves.com>)
List pgsql-general
On Fri, Apr 24, 2020 at 8:55 AM Steve Clark <steve.clark@netwolves.com> 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?


Aborts

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: psql \copy
Next
From: Steve Crawford
Date:
Subject: Re: psql \copy