Re: Can't populate database using Copy

Try this:

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