On Fri, Apr 24, 2020 at 8:55 AM Steve Clark <steve.clark@xxxxxxxxxxxxx> 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?
The copy will fail. You could import into a temporary table and preprocess then copy to your permanent table or use an ETL solution to remove unwanted data before importing. I don't know the nature of your data or project but perhaps that column isn't suitable for a key.
Cheers,
Steve
