copy the file "FinalData.txt" to the 'bin' folder of pgsql where postgres binaries are located and then try doing the COPY using
copy tabledaily from 'FinalData.txt ' with csv;
and see if it solves the problem or not?
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 8/27/06,
Michael Fuhr <mike@xxxxxxxx> wrote:
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 permissions were changed for world access ( perhaps bad idea
> but out of frustration; and am the only person on this computer ).
> drwxrwxrwx 3 root root 4096 Aug 21 10:19 home
> drwxrwxrwx 25 jb jb 4096 Aug 26 11:18 jb
> -rwxrwxrwx 1 jb jb 255 Aug 25 18:15 FinalData.txt
Might this be an SELinux problem?
--
Michael Fuhr
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
