Load data from a csv file without using COPY

Поиск
Список
Период
Сортировка
От Ravi Krishna
Тема Load data from a csv file without using COPY
Дата
Msg-id AE89FBE5-B726-4108-925F-449E34D24651@yahoo.com
обсуждение исходный текст
Ответы Re: Load data from a csv file without using COPY  (Nicolas Paris <niparisco@gmail.com>)
Re: Load data from a csv file without using COPY  (Hans Schou <hans.schou@gmail.com>)
Re: Load data from a csv file without using COPY  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Load data from a csv file without using COPY  (Steve Atkins <steve@blighty.com>)
Re: Load data from a csv file without using COPY  (Alban Hertroys <haramrae@gmail.com>)
Re: Load data from a csv file without using COPY  (Tim Cross <theophilusx@gmail.com>)
Re: Load data from a csv file without using COPY  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: Run Stored procedure - function from VBA
Следующее
От: Nicolas Paris
Дата:
Сообщение: Re: Load data from a csv file without using COPY