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 [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
