Re: Load data from a csv file without using COPY

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Load data from a csv file without using COPY
Дата
Msg-id 0bcfb5d0-f51f-0ca7-1ca9-b967cc110e81@aklaver.com
обсуждение исходный текст
Ответ на Load data from a csv file without using COPY  (Ravi Krishna <srkrishna@yahoo.com>)
Список pgsql-general
On 06/19/2018 01:16 PM, Ravi Krishna wrote:
> 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.

http://csvkit.readthedocs.io/en/1.0.3/scripts/csvsql.html
> 
> thanks
> 
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


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

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