COPY TO / COPY FROM

From: Cédric Buschini <cbuschini(at)carax(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: COPY TO / COPY FROM
Date: 2005-09-23 11:48:33
Message-ID: 4333EB91.7020909@carax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

Hi

Here I am again with my 'stupd' question

here is a script :

=====================
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

????

thx

cedric

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Aldor 2005-09-23 12:02:29 Re: COPY TO / COPY FROM
Previous Message Aldor 2005-09-23 09:12:33 Re: Replication

Browse pgsql-sql by date

  From Date Subject
Next Message Aldor 2005-09-23 12:02:29 Re: COPY TO / COPY FROM
Previous Message Stewart Ben (RBAU/EQS4) * 2005-09-23 05:55:54 Re: Functions, transactions and RETURN