title: Ignore Postgresql batch insert errors
body: <p>Assume this simple SQL query: </p>
  
  <pre><code>INSERT INTO table (col1,col2) VALUES (val1,val2),(val3,val4),(val5,val6);
  </code></pre>
  
  <p>Lets say <code>val3</code> is invalid value for <code>col1</code>. This would cause psql to abort whole INSERT command - it would not insert <code>(val1,val2)</code> nor <code>(val5,val6)</code> either.</p>
  
  <p>Is it possible to make postgresql ignore this error so it does not insert <code>(val3,val4)</code> pair but would still proceed with <code>(val1,val2)</code> and <code>(val5,val6)</code>? </p>
  
  <p>I'm getting daily database dumps in text files from my partner (can't change that), which I use to make my copy of it. Sometimes his huge INSERT queries cause errors like:</p>
  
  <pre><code>ERROR:  invalid byte sequence for encoding "UTF8": 0x00
  </code></pre>
  
  <p>... which makes whole 30000+ values not inserted to the table, because one of those values is wrong. </p>