title: PostgreSQL csv import from a MySQL csv export?
body: <p>Will it work? </p>
  
  <p>MySQL export:</p>
  
  <pre><code>SELECT * INTO OUTFILE 'C:/data.csv'
  FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"'
  ESCAPED BY '\\'
  LINES TERMINATED BY '\n'
  FROM table;
  </code></pre>
  
  <p>PostgreSQL:</p>
  
  <pre><code>COPY table FROM 'C:/data.csv' WITH DELIMITER AS '\t' NULL AS '\\N' CSV
  </code></pre>
  
  <p>There is missing columns for some reason. So I believe there is problem in delimiter. Am I correct, what can I do? I can inspect row with cause error below. But which characters I must look for?</p>
  
  <pre><code>ERROR:  missing data for column "Column21"
  CONTEXT:  COPY table, line 88219: ...
  </code></pre>