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)