Re: COPY TO / COPY FROM

On Fri, Sep 23, 2005 at 01:48:33PM +0200, Cédric Buschini wrote:
> =====================
> psql -h192.168.XXX.XXX -dDATABASE -Upostgres << EOF  > /home/postgres/FILE
> COPY TABLE TO stdout;
> EOF
>
> psql -h192.168.XXX.XXX -dDATABASE -Upostgres << EOF
> COPY carax_exec_bck FROM '/home/postgres/FILE';
> EOF
> =======================
>
> I got this error :
> ERROR:  could not open file "/home/postgres/FILE" for reading: No such
> file or directory

Are the client and server on the same machine?  The use of the -h
option suggests perhaps not.  In the first command you're redirecting
psql's output to a file on the client machine, and in the second
command you're trying to read a file on the server machine.

--
Michael Fuhr