Give the fullname of the file. Make sure the file is on the server machine and not your local machine (in case you are forwarding pgaccess to another X terminal) cheers, thalis On 16 Jun 2001, Chakravarthy K Sannedhi wrote: > Hi, > > When I am trying to import a file in my home directory into the the > pgsql database using the *pgaccess* gui tool, it is giving the > following message. > > ERROR: COPY command, running in backend with effective uid 26, could > not open file 'myfile' for reading. Errno=No such file > > Can any one please tell me what I am missing here. Is it necessary for > the 'postgresql' to own the file named 'myfile' under my home > directory. > > TIA > Chakravarthy K Sannedhi > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
