Postgres Pro
Downloads
Home   >   mailing lists

Load data from a csv file without using COPY - Mailing list pgsql-general

From Ravi Krishna
Subject Load data from a csv file without using COPY
Date
Msg-id AE89FBE5-B726-4108-925F-449E34D24651@yahoo.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Run Stored procedure - function from VBA
Next
From: Nicolas Paris
Date:
Subject: Re: Load data from a csv file without using COPY