Re: problems with copy

"Steff" <stephane(dot)eveillard(at)netcourrier(dot)com> writes:

> I'm starting using PostgreSQL and want to import datas from my old database.
> I've made ASCII delimited files and want to use the copy instruction.
>
> Having the server started, I do the following :
>
> > psql mydb
> >copy table from 'myfile' using delimiters ';' ;
>
> I'vegot an error saying that the backend server can't read myfile. I've
> check rights on this file and every user can read this file.
> I've created the table and checked that it exists.

Some possibilities:

* The backend can't find the file because you're using a relative
pathname. Try using an absolute pathname (one that starts with
'/'). The backend has its own working directory, which is generally
different from that of the 'psql' process.
* The 'postgres' user doesn't have read/search permission on one of
the directories leading to the file (eg, if /home/doug is not
world-searchable, no other user can read /home/doug/myfile, no
matter what permissions are on 'myfile' itself).

-Doug