using psql copy command
От | David Bear |
---|---|
Тема | using psql copy command |
Дата | |
Msg-id | 20041108234434.GA25665@asu.edu обсуждение исходный текст |
Ответы |
Re: using psql copy command
|
Список | pgsql-admin |
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"
В списке pgsql-admin по дате отправления: