| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |