Re: Load data from a csv file without using COPY

Поиск
Список
Период
Сортировка
От Nicolas Paris
Тема Re: Load data from a csv file without using COPY
Дата
Msg-id CA+ssMORgpZW+iUNaNGsaxSHbHie+dwrB80Bd0y7jB3WJeSz7cQ@mail.gmail.com
обсуждение исходный текст
Ответ на Load data from a csv file without using COPY  (Ravi Krishna <srkrishna@yahoo.com>)
Ответы Re: Load data from a csv file without using COPY
Список 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@yahoo.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





В списке pgsql-general по дате отправления:

Предыдущее
От: Ravi Krishna
Дата:
Сообщение: Load data from a csv file without using COPY
Следующее
От: Hans Schou
Дата:
Сообщение: Re: Load data from a csv file without using COPY