title: PostgreSQL escape character during copy
body: <p>I'm trying to import a CSV file into PostgreSQL but I am having an issue with special characters.</p>
  
  <p>I'm using the following command</p>
  
  <pre><code>./psql -d data -U postgres -c "copy users from 'users.csv' delimiter E'\t' quote '~' csv"
  </code></pre>
  
  <p>It works fine until it encounters a field with the '~' which I'm using as a quote value to not break the existing quotes and inverted commas etc.</p>
  
  <p>How do I escape this character in the csv file 'Person~name' so that it will import as 'Person~name'</p>