P Kapat <kap4lin(at)gmail(dot)com> writes:
> ... Now I want to copy a csv file, which is on the
> local client machine, into a table on the remote server machine. I try
> to do so via:
> COPY myschm.mytb FROM '/home/myuser/myfile.csv' WITH CSV header
> QUOTE AS '\"';
> which clearly doesn't work, giving: ERROR: could not open file ......
> No such file or directory
Of course it won't work; that command reads files on the server's
filesystem. Use psql's \copy command to copy files from/to the client
filesystem.
regards, tom lane