Re: psql \copy

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Steve Clark <steve(dot)clark(at)netwolves(dot)com>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: psql \copy
Date: 2020-04-24 15:59:46
Message-ID: CAKFQuwav9XoQuxZ8pruw=ODDmWGYrrUUOgwQ1S9jvUbgigLAxA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 24, 2020 at 8:55 AM Steve Clark <steve(dot)clark(at)netwolves(dot)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

In response to

  • psql \copy at 2020-04-24 15:55:34 from Steve Clark

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2020-04-24 15:59:54 Re: psql \copy
Previous Message Adrian Klaver 2020-04-24 15:59:33 Re: psql \copy