Quick Links

Load data from a csv file without using COPY

From:	Ravi Krishna <srkrishna(at)yahoo(dot)com>
To:	PG mailing List <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject:	Load data from a csv file without using COPY
Date:	2018-06-19 20:16:41
Message-ID:	AE89FBE5-B726-4108-925F-449E34D24651@yahoo.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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

Responses

Re: Load data from a csv file without using COPY at 2018-06-19 20:30:15 from Nicolas Paris
Re: Load data from a csv file without using COPY at 2018-06-19 20:31:56 from Hans Schou
Re: Load data from a csv file without using COPY at 2018-06-19 20:49:33 from David G. Johnston
Re: Load data from a csv file without using COPY at 2018-06-19 21:09:22 from Steve Atkins
Re: Load data from a csv file without using COPY at 2018-06-19 21:10:04 from Alban Hertroys
Re: Load data from a csv file without using COPY at 2018-06-19 21:59:10 from Tim Cross
Re: Load data from a csv file without using COPY at 2018-06-19 22:38:29 from Adrian Klaver

Browse pgsql-general by date

	From	Date	Subject
Next Message	Andres Freund	2018-06-19 20:18:46	Re: found xmin from before relfrozenxid on pg_catalog.pg_authid
Previous Message	Matheus de Oliveira	2018-06-19 20:05:48	Re: found xmin from before relfrozenxid on pg_catalog.pg_authid