Give the fullname of the file. Make sure the file is on the server machine and not your local machine (in case you are
forwardingpgaccess 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
>