Re: Load data from a csv file without using COPY

From: Nicolas Paris <niparisco(at)gmail(dot)com>
To: Ravi Krishna <srkrishna(at)yahoo(dot)com>
Cc: PG mailing List <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Load data from a csv file without using COPY
Date: 2018-06-19 20:30:15
Message-ID: CA+ssMORgpZW+iUNaNGsaxSHbHie+dwrB80Bd0y7jB3WJeSz7cQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi

AFAIK you can use copy from a jdbc command since copy allows to stream data
(from stdin version)
However while faster than INSERT INTO, this might lock the target table
during the process

2018-06-19 22:16 GMT+02:00 Ravi Krishna <srkrishna(at)yahoo(dot)com>:

> In order to test a real life scenario (and use it for benchmarking) I want
> to load large number of data from csv files.
> The requirement is that the load should happen like an application writing
> to the database ( that is, no COPY command).
> Is there a tool which can do the job. Basically parse the csv file and
> insert it to the database row by row.
>
> thanks
>
>
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hans Schou 2018-06-19 20:31:56 Re: Load data from a csv file without using COPY
Previous Message Andres Freund 2018-06-19 20:18:46 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid