David Bear
2004-11-08 23:44:34 UTC
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:
***@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
***@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"
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
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:
***@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
***@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"
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match