title: Copy multiple CSV files into postgres
body: <p>I am writing a SQL script to copy multiple .CSV files into a postgres database like this:</p>
  
  <pre><code>COPY product(title, department) from 'ys.csv' CSV HEADER;
  </code></pre>
  
  <p>I have multiple files I want to copy in.  I don't want: </p>
  
  <pre><code>COPY product(title, department) from 'ys1.csv' CSV HEADER;
  COPY product(title, department) from 'ys2.csv' CSV HEADER;
  COPY product(title, department) from 'ys3.csv' CSV HEADER;
  COPY product(title, department) from 'ys4.csv' CSV HEADER;
  COPY product(title, department) from 'ys5.csv' CSV HEADER;
  </code></pre>
  
  <p>I would like to use a for loop for this instead of multiple copy commands. Is this possible? Thanks</p>