title: postgresql - pgloader - quotes handling
body: <p>I am new to postgresql and just starting to use it. I am trying to load a file into a table and facing some issues. </p>
  
  <p>Sample data - the file file1.RPT contains data in the below format</p>
  
  <pre><code>"Bharath"|Kumar|Krishnan
   abc"|def|ghi
   qwerty|asdfgh|lkjhg
  </code></pre>
  
  <p>Below is the load script that is used</p>
  
  <pre><code>LOAD CSV
  INTO table1
  ....
  WITH truncate,
  fields optionally enclosed by '"',
  fields escaped by '"'
  fields terminated by '|'
  ....
  </code></pre>
  
  <p>However, the above script is not working and is not loading any data into the table. I am not sure whats the issue here. My understanding is that first row data has to be successfully loaded (since I have given optionally enclosed by) and the second row also must be loaded (since I am trying to escape the double quote).</p>
  
  <p>Request help in getting the same rectified.</p>
  
  <p>Thank you.</p>