| From: | Steve Crawford <scrawford(at)pinpointresearch(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:54 |
| Message-ID: | CAEfWYyyZQMxWak8WRXZWZ8jZ5+x9QJPvDD5EYGFtrVvFnD4U1Q@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?
>
>
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Clark | 2020-04-24 16:12:30 | Re: psql \copy |
| Previous Message | David G. Johnston | 2020-04-24 15:59:46 | Re: psql \copy |