title: psql ERROR: could not open file "address.csv" for reading: No such file or directory
body: <p>A newbie to Linux.</p>
  
  <p>I am trying to copy a .csv into a PostgreSQL database,</p>
  
  <p><code>copy address from 'address.csv' delimiter ',' csv header;</code></p>
  
  <p>I have cd to location of file, using the \cd [directory] command at the psql prompt. An unsuccessful action.</p>
  
  <p>I have closed that terminal window and in another terminal window cd to the data folder and from there there I have opened the psql command.</p>
  
  <p><code>\! pwd</code> displays the name/path of folder where the file is stored.
  <code>/home/tommy/virtualenv_folder/code_data/postgresql_csv_files</code></p>
  
  <p><code>\! ls</code> displays the file name, even using the wildcard <code>\! add*</code> displays the file name.</p>
  
  <p>stackoverflow.com/questions/16618299/postgres-copy-from-csv-file-no-such-file-or-directory
  suggests to reset the <em>search_path</em>. Being in the data folder surely this is not necessary. Or is it?</p>
  
  <p>Anyway, any pointers would be appreciated, please.</p>