Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there any equivalent of SQLBulkCopy in Npgsql

After some goоgling, I could not find a proper replacement of SQLBulkCopy from SQLClient in Npgsql. Can any body suggest me anything like SQLBulkCopy for PostgreSQL? I need to insert around 10 millions of data.. I know about making single query insertion...

I am just doing test for comparison purpose.

Any suggestion is appreciated.

like image 391
Mehbube Arman Avatar asked Jan 28 '14 14:01

Mehbube Arman


1 Answers

Very old now, but note that Npgsql 3 includes an optimized binary bulk copy functionality, see the docs (3.0).

like image 135
Shay Rojansky Avatar answered Oct 07 '22 18:10

Shay Rojansky