title: PostgreSQL COPY csv including Quotes
body: <p>This is a very simple problem, I am using the psql terminal command COPY as shown bellow</p>
  
  <pre><code>COPY tbname FROM '/tmp/file.csv'
  delimiter '|' csv;
  </code></pre>
  
  <p>However this file.csv contains data such as</p>
  
  <pre><code>random|stuff|32"
  </code></pre>
  
  <p>as well as</p>
  
  <pre><code>random|other "stuff"|15
  </code></pre>
  
  <p>I tried to use the double quote to escape the quotes as the Postgres site suggested</p>
  
  <pre><code>random|stuff|32""
  random|other ""stuff""|15
  </code></pre>
  
  <p>This seems to remove the quotes completely which I don't want.
  Is there a way to get the import to just treat these quotes as regular characters so that they appear in the database as they do in the csv file?</p>