title: psql /copy “No such file or directory”
body: <p>I have created a table called "new_test" on my postgres server and I'm trying to copy from a CSV file on my local Mac called "test.csv" to my new table.  Both my "new_test" table and my "test.csv" file have one column called "compkey".  I only have 4 rows in the csv file.  May psql command is as follows:</p>
  
  <p><code>\copy new_test(COMPKEY) from ‘TEST.csv’ with delimiter ‘,’ csv header;</code></p>
  
  <p>But I keep getting this error message: <code>‘TEST.csv’: No such file or directory</code></p>
  
  <p>I have tried <code>\cd</code> to get to the correct filepath and have confirmed I'm in the right folder with <code>\! ls</code>, seeing the "TEST.csv" file listed.  I have also tried the absolute path on my Mac, like this: </p>
  
  <p><code>\copy new_test(COMPKEY) from '/Users/the/rest/of/the/file/path/TEST.csv’ with delimiter ‘,’ csv header;</code> </p>
  
  <p>...but I get the same error message.  What am I doing wrong or missing?</p>