X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D846FD8EA0 for ; Fri, 23 Sep 2005 08:48:42 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41104-07 for ; Fri, 23 Sep 2005 11:48:35 +0000 (GMT) Received: from smtp-ft1.fr.colt.net (smtp-ft1.fr.colt.net [213.41.78.210]) by svr1.postgresql.org (Postfix) with ESMTP id 234EED8D9A for ; Fri, 23 Sep 2005 08:48:34 -0300 (ADT) Received: from [192.168.10.52] (www.carax.com [62.23.146.21]) by smtp-ft1.fr.colt.net (8.13.4/8.13.4/Debian-3) with ESMTP id j8NBmXwe019206 for ; Fri, 23 Sep 2005 13:48:33 +0200 Message-ID: <4333EB91.7020909@carax.com> Date: Fri, 23 Sep 2005 13:48:33 +0200 From: =?ISO-8859-1?Q?C=E9dric_Buschini?= Reply-To: cbuschini@carax.com Organization: CARAX User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.5) Gecko/20041217 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: COPY TO / COPY FROM Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.899 required=5 tests=[AWL=-0.259, HOT_NASTY=0.586, SUBJ_ALL_CAPS=0.365, UPPERCASE_25_50=0.207] X-Spam-Level: X-Archive-Number: 200509/267 X-Sequence-Number: 19004 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