X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F3C923A408C for ; Mon, 8 Nov 2004 23:46:01 +0000 (GMT) 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 81473-10 for ; Mon, 8 Nov 2004 23:45:57 +0000 (GMT) Received: from post5.inre.asu.edu (post5.inre.asu.edu [129.219.110.120]) by svr1.postgresql.org (Postfix) with ESMTP id 473233A40FA for ; Mon, 8 Nov 2004 23:45:59 +0000 (GMT) Received: from conversion.post5.inre.asu.edu by asu.edu (PMDF V6.1-1X6 #30769) id <0I6V00601WM9FV@asu.edu> for pgsql-admin@postgresql.org; Mon, 08 Nov 2004 16:44:33 -0700 (MST) Received: from smtp.asu.edu (smtp.asu.edu [129.219.110.107]) by asu.edu (PMDF V6.1-1X6 #30769) with ESMTP id <0I6V00649WM9BE@asu.edu> for pgsql-admin@postgresql.org; Mon, 08 Nov 2004 16:44:33 -0700 (MST) Received: from moroni.pp.asu.edu (moroni.pp.asu.edu [129.219.69.200]) by smtp.asu.edu (8.12.10/8.12.10/asu_smtp_relay, nullclient, tcp_wrapped) with ESMTP id iA8NiXMC013441 for ; Mon, 08 Nov 2004 16:44:33 -0700 (MST) Received: by moroni.pp.asu.edu (Postfix, from userid 500) id 61E56E8F; Mon, 08 Nov 2004 16:44:34 -0700 (MST) Date: Mon, 08 Nov 2004 16:44:34 -0700 From: David Bear Subject: using psql copy command To: postgresql@moroni.pp.asu.edu, pgsql-admin@postgresql.org Reply-To: David.Bear@asu.edu Message-id: <20041108234434.GA25665@asu.edu> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-disposition: inline User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/69 X-Sequence-Number: 15454 I'm getting fairly frustrated here. I'm trying to populate a table using psql copy command. The file lives in the client machine where psql is running, not on the back end. I assume from the readings that I can you the \copy command to get to data in my clients file system. Yet, its not working.. Here are the commands: iddwb@moroni:~/data/copp/dev/npcenter> ls -l total 231 -rw-r--r-- 1 3117 iddwb 88979 2004-11-08 16:32 contactName.txt -rw------- 1 3117 iddwb 145024 2004-11-08 16:09 tblContactNames.txt iddwb@moroni:~/data/copp/dev/npcenter> psql -p 5432 -h localhost npcenter -U david npcenter=> \copy "contactName" from "/home/iddwb/data/copp/dev/npcenter/contact Name.txt" "/home/iddwb/data/copp/dev/npcenter/contactName.txt": No such file or directory npcenter=> \copy "contactName" from "./contactName.txt" "./contactName.txt": No such file or directory npcenter=> I must be missing something very obvious.. Help... -- David Bear phone: 480-965-8257 fax: 480-965-9189 College of Public Programs/ASU Wilson Hall 232 Tempe, AZ 85287-0803 "Beware the IP portfolio, everyone will be suspect of trespassing"