Re: Load data from a csv file without using COPY

On Tue, Jun 19, 2018 at 2:17 PM, Ravi Krishna <srkrishna(at)yahoo(dot)com> wrote:

> >
> > I think an easy approach would be to COPY the CSV files into a separate
> database using psql's \copy command and then pg_dump that as separate
> insert statements with pg_dump —inserts.
> >
>
> This was my first thought too. However, as I understand, pg_dump --insert
> basically runs INSERT INTO ... sql for every row.
> In other words, each row is un-prepared and executed individually. That
> is also not real life scenario.
>

​You really need to describe what you consider to be a "real life​
scenario"; and probably give a better idea of creation and number of these
csv files. In addition to describing the relevant behavior of the
application you are testing.

If you want maximum realism you should probably write integration tests for
your application and then execute those at high volume.

Or at minimum give an example of the output you would want from this
unknown program...

David J.