title: PostGreSQL CSV import line separator
body: <p>I am trying to export data from MySQL table and import that data into the PgSQl database.</p>
  
  <p><strong>EXPORT Script from MySQL</strong></p>
  
  <pre><code>select column_names from from table_name LIMIT 2
  INTO OUTFILE 'E:/CSV_files/record_main.csv'
  FIELDS TERMINATED BY ','
  ENCLOSED BY '"'
  LINES TERMINATED BY ';'
  </code></pre>
  
  <p><strong>PgSQL IMPORT script</strong></p>
  
  <pre><code>COPY record_main("column_names ") FROM 'E:/CSV_files/record_main.csv' 
  WITH DELIMITER ',' NULL '\N'   ESCAPE ';' CSV
  </code></pre>
  
  <p>The above code is working fine for me when i am trying to export and import the CSV. </p>
  
  <p>But while i am increasing the selection limit 1 to 2 or any , It causes  error.</p>
  
  <blockquote>
    <p>ERROR:  extra data after last expected column
    CONTEXT:  COPY record_main, line 1: >""12635","55025","1","ASCS","P","5320700","2015-01-01 >00:00:00",\N,\N,\N,\N,\N,\N,"DEED",\N,\N,\N,\N,..."</p>
  </blockquote>
  
  <p>Then opened the CSV file and i manually separated the one row of data in to two row of data.</p>
  
  <p>And i removed the semicolon from the end of each line. </p>
  
  <p>This time it is working fine.
  I think error in the line separator. My question is how can i say to the PgSQl to the line separator is this. like i given the <code>DELIMITER</code></p>