Re: error during copying .txt file

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(at)postgresql(dot)org)