title: Importing csv file into postgres db using pgadmin with special characters
body: <p>I'm importing data from <code>csv</code> file into <code>postgres db</code> using <code>pgadmin 4</code>
  Everything is ok but I get an issue when I try to import a file which contain some data like this</p>
  
  <blockquote>
    <p>“‘t Zand, Vlotbrug”</p>
    
    <p>“Dussen, `t Middeltje”</p>
  </blockquote>
  
  <p>as you can see, the data contains </p>
  
  <blockquote>
    <p>`</p>
  </blockquote>
  
  <p>and </p>
  
  <blockquote>
    <p>'</p>
  </blockquote>
  
  <p>I also tried to import the file with utf-8 encoding but could not.</p>
  
  <p>Anyone knows how to solve this issue?</p>
  
  <p><strong>Updated</strong></p>
  
  <p>Structure:</p>
  
  <pre><code>stop_id,stop_code,stop_name,stop_lat,stop_lon,location_type,parent_station,stop_timezone,wheelchair_boarding,platform_code,zone_id
  </code></pre>
  
  <p>Data:</p>
  
  <pre><code>stoparea:123953,,"De Zande, 'Koelucht'",52.5184475,5.956368,1,,,0,,
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>ERROR:  unterminated CSV quoted field
  CONTEXT:  COPY stops, line 69400: "stoparea:123953,,"De Zande, 'Koelucht'",52.5184475,5.956368,1,,,0,,
  stoparea:120536,,"Poortvliet, Zu..."
  </code></pre>
  
  <p><strong>Updated 2</strong></p>
  
  <p>Command:</p>
  
  <blockquote>
    <p>"/Applications/pgAdmin 4.app/Contents/SharedSupport/psql" --command "
    "\copy transit.stops (stop_id, stop_code, stop_name, stop_lat,
    stop_lon, location_type, parent_station, stop_timezone,
    wheelchair_boarding, platform_code, zone_id) FROM
    '/Users/tvtan/Desktop/gtfs-nl/stops.txt' DELIMITER ',' CSV HEADER
    QUOTE '\"' ESCAPE '''';""</p>
  </blockquote>
  
  <p>UI:</p>
  
  <p><a href="https://i.stack.imgur.com/8ENJX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8ENJX.png" alt="enter image description here"></a></p>