title: How to import table from PostgreSQL to SAP Hana?
body: <p>I'm trying to export data from <code>PostgreSQL</code> and import it into <code>SAP Hana</code>. The problem which is <code>'\n'</code> i.e. line breaks are getting automatically removed from the TEXT data.</p>
  
  <p>Example: </p>
  
  <pre class="lang-none prettyprint-override"><code>A 1,750 word essay is 11 to 12 paragraphs.
  A 2,000 word essay is 13 to 14 paragraphs.
  A 2,500 word essay is 16 to 17 paragraphs.
  A 3,000 word essay is 20 paragraphs.
  </code></pre>
  
  <p>Is becoming </p>
  
  <pre class="lang-none prettyprint-override"><code>A 1,750 word essay is 11 to 12 paragraphs.A 2,000 word essay is 13 to 14 paragraphs.A 2,500 word essay is 16 to 17 paragraphs.A 3,000 word essay is 20 paragraphs.
  </code></pre>
  
  <p>I'm using below commands:</p>
  
  <p>PostgreSQL </p>
  
  <pre class="lang-none prettyprint-override"><code>\COPY table_name TO 'path\data.csv' WITH CSV DELIMITER ',';
  </code></pre>
  
  <p>Hana</p>
  
  <pre class="lang-none prettyprint-override"><code>IMPORT FROM CSV FILE path
  INTO table_name
  WITH RECORD DELIMITED BY '\n'
  FIELD DELIMITED BY '\t'
  OPTIONALLY ENCLOSED BY '"';
  </code></pre>