Try this:copy the file "FinalData.txt" to the 'bin' folder of pgsql where postgres binaries are located and then try doing the COPY usingcopy tabledaily from 'FinalData.txt
' with csv;and see if it solves the problem or not?-- Shoaib MirEnterpriseDB (www.enterprisedb.com)On 8/27/06,
Michael Fuhr <
On Sat, Aug 26, 2006 at 11:35:56AM -0700, Jim wrote:
> copy tabledaily from '/home/jb/FinalData.txt' with csv;
> ERROR: could not open file "/home/jb/FinalData.txt" for reading: Permission
> denied.
> Yet everything else works, including populating tables with Insert queries.
>
> All the permiss