title: How can I use COPY in postgresql if it said that I do not have the permission to do it?
body: <p>I'm using DBeaver for my little projet. I'm actually stuck because the "COPY" command can't work because I don't have superuser permission. Here's my code:</p>
  
  <pre><code>copy "TableName" FROM 'The_location_of_my_csv_file' WITH DELIMITER AS ';' csv header;
  </code></pre>
  
  <p>That resulted in the following error:</p>
  
  <blockquote>
    <p>ERROR: must be superuser or a member of the pg_read_server_files role
    to COPY from a file</p>
  </blockquote>
  
  <p>So I need help on how to use \copy because it has a syntax error when I run it.</p>
  
  <p>By the way, I need a solution where I use the "COPY" command on DBeaver and NOT in the CMD or other terminal!</p>
  
  <p>I'm sorry if it looks like a silly question btw, but I'm a newbie on postgresql.</p>