Re: [ADMIN] using psql copy command

2004-11-08 Thread Tom Lane
David Bear <[EMAIL PROTECTED]> writes: > npcenter=> \copy "contactName" from > "/home/iddwb/data/copp/dev/npcenter/contactName.txt" > "/home/iddwb/data/copp/dev/npcenter/contactName.txt": No such file or > directory > I must be missing something very obvious.. Help... Use single quotes, or none

[ADMIN] using psql \copy command

2004-11-08 Thread David Bear
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..

[ADMIN] using psql copy command

2004-11-08 Thread David Bear
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.. H