Re: [GENERAL] Can't populate database using Copy

2006-08-27 Thread Shoaib Mir
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 <

Re: [GENERAL] Can't populate database using Copy

2006-08-26 Thread 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