Обсуждение: error during copying .txt file
hi, can you help me to solve this problem.. copy hour from '/home/staff/band.txt' using delimiters ','; ERROR: COPY command, running in backend with effective uid 26, could not open file '/home/staff/band.txt' for reading. Errno = Permission denied (13). i am very greatful to you if you able to solve my problem. Thanks In advance Tulasi __________________________________________________ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/
set the folders' as well as file's permission chmod o+x /home chmod o+x /home/staff chmod o+r band.txt Banghe rama tulasi wrote: > hi, > can you help me to solve this problem.. > copy hour from '/home/staff/band.txt' using delimiters > ','; > ERROR: COPY command, running in backend with > effective uid 26, could not open file > '/home/staff/band.txt' for reading. Errno = > Permission denied (13). > > i am very greatful to you if you able to solve my > problem. > > Thanks In advance > Tulasi > > __________________________________________________ > Do You Yahoo!? > Yahoo! Sports - live college hoops coverage > http://sports.yahoo.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Rama, Are psql and the postgres server on the same machine? If so, make sure the file is world readable (and the directories as well). If not, try: psql -h host -d database -c "copy hour from stdin delimiters ',';" < /home/staff/band.txt rama tulasi wrote: > > hi, > can you help me to solve this problem.. > copy hour from '/home/staff/band.txt' using delimiters > ','; > ERROR: COPY command, running in backend with > effective uid 26, could not open file > '/home/staff/band.txt' for reading. Errno = > Permission denied (13). > > i am very greatful to you if you able to solve my > problem. > > Thanks In advance > Tulasi > > __________________________________________________ > Do You Yahoo!? > Yahoo! Sports - live college hoops coverage > http://sports.yahoo.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)