title: PostgreSQL's COPY statement
body: <p>Using COPY statement of PostgreSQL, we can load data from a text file into data base's table as below:</p>
  
  <p><code>COPY CME_ERROR_CODES FROM E'C:\\Program Files\\ERROR_CODES\\errcodes.txt' DELIMITER AS '~'</code></p>
  
  <p>The above statement is run from a machine which has postgresql client where as the server is in another windows machine. Running the above statement is complaining me that <code>ERROR:  could not open file "C:\Program Files\ERROR_CODES\errcodes.txt" for reading: No such file or directory</code>. 
  <p>
  After some research, i observed that <code>COPY</code> statement is looking for the loader file(errcodes.txt) in the postgresql server's machine at the same path (C:\Program Files\ERROR_CODES). To test this , i have create the same folder structure in the postgresql server's machine and kept the errcodes.txt file in there. Then the COPY statement worked well. It looks very tough constraint for me with COPY statement. 
  Is there any setting needed to avoid this? or it is the behavior of COPY statement? I didn't find any information on PostgreSQL documents.</p>