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.