Postgresql multi-row insert using command parameters

Question

I need to insert large amounts of data into postgresql using multi-row inserts.

I am currently doing this by constructing the sql query using a stringbuilder and appending the values but I was wondering if there is a way to use commands and command parameters instead?

Thanks. I have already checked that and I was having problems because of the data I need to import — dp901
– dp901, Commented Jun 5, 2013 at 15:02
Consider COPYing to a TEMPORARY or UNLOGGED table then doing an INSERT INTO ... SELECT to insert a massaged version of the data into the real target table. — Craig Ringer
– Craig Ringer, Commented Jun 5, 2013 at 23:49

Community · Accepted Answer · 2017-05-23 12:28:57Z

2

Here is good copy guide for inserting big amount of data.
Here is good answer for similar question

edited May 23, 2017 at 12:28

CommunityBot

11 silver badge

answered Jun 4, 2013 at 15:56

Andriy Kizym

1,7962 gold badges16 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql multi-row insert using command parameters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related