title: Postgres COPY command with literal delimiter
body: <p>I was trying to import a CSV file into a <strong>PostgreSQL</strong> table using the <em>COPY</em> command. The delimiter of the <em>CSV</em> file is comma (,). However, there's also a text field with a comma in the value. For example:</p>
  
  <pre><code>COPY schema.table from '/folder/foo.csv' delimiter ',' CSV header
  </code></pre>
  
  <p>Here's the content of the <code>foo.csv</code> file:</p>
  
  <pre><code>Name,Description,Age
  John,Male\,Tall,30
  </code></pre>
  
  <p>How to distinguish between the literal comma and the delimiter?</p>
  
  <p>Thanks for your help.</p>