Bulk C# datatable to postgresql table
<p>I have got a datatable with thousands of records.
I have got a postgres table with the same fields of the datatable.
I want everyday to truncate this table and fill again with the data of the datatable. I have seen sql bulk copy, but it is not avalaible on postgres.
So, which one is the most effective way?</p>

<ul>
<li>One insert per record</li>
<li>Multiple insert: insert into table values (1,1),(1,2),(1,3),(2,1);</li>
<li>Select from datatable and insert into postgres with linq? no idea...</li>
</ul>

<p>Thanks.</p>