title: Import/ Copy csv file into PostgreSQL | File not on local Server
body: <p>I am trying to import/ copy my csv file to PostgreSQL. However, I am encountering these errors. I don't have import/ write permissions to the file. Will stdin help and how?The Postgres docs provides no examples. I was henceforth asked to do bulk insert but since there are too many columns with mixed data types, I am not sure how to proceed with that further.</p>
  
  <p><strong>Command to copy the csv file:</strong></p>
  
  <pre><code>COPY sales.sales_tickets 
  FROM 'C:/Users/Nandini/Downloads/AIG_Sales_Tickets.csv' 
  DELIMITER ',' CSV;
  </code></pre>
  
  <blockquote>
    <p>ERROR: must be superuser to COPY to or from a file<br>
    Hint: Anyone can COPY to stdout or from stdin. psql's \copy command also works for anyone.<br>
    1 statement failed.</p>
  </blockquote>
  
  <p><strong>Command to do bulk insert is too time taking:</strong></p>
  
  <pre><code>insert into sales.sales_ticket values (1,'2',3,'4','5',6,7,8,'9',10','11');
  </code></pre>
  
  <p>Please suggest. Thank you.</p>