title: How do i import .csv file from a remote server to a postgreSQL database?
body: <p>The original code is a simple SQL import :</p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'D:/FTP/foo/foo.csv'
  
  INTO TABLE error_logs
  
  FIELDS TERMINATED BY ','
  ENCLOSED BY '"' 
  ESCAPED BY ''
  LINES STARTING BY ''
  TERMINATED BY '\n' 
  
  IGNORE 1 LINES
  
  (Server,Client,Error,Time);
  </code></pre>
  
  <p>I need to migrate a web portal (from SQL to Postgres[I know there are tools for that, but its not the question]) and the issue is i am no more working on local.</p>
  
  <p>I didn't see anybody ask the question in this way : import .csv from a remote server to a postgres db.</p>
  
  <p>I think i have to use COPY but i dont get the right syntax... </p>
  
  <p>Thanks for your attention.</p>