[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: psql \copy
From:       Ron <ronljohnsonjr () gmail ! com>
Date:       2020-04-24 16:36:47
Message-ID: 21c97985-7126-f71a-ff4a-da6e10e9ab76 () gmail ! com
[Download RAW message or body]

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.


[prev in list] [next in list] [prev in thread] [next in thread]