Re: the copy command

On Monday 10 September 2007 17:31, Tom Lane wrote:
> johnf <jfabiani@yolo.com> writes:
> > When I use a copy command from the pgadmin query screen  as in:
> >
> > COPY agschgrid (tablename, header1, header2, header3, header4, header5,
> > coldata1, coldata3, coldata2, coldata4, coldata5, retfield, pkid, prikey,
> > colcount, lookupfld, regid, lk_filter, "txtBoxID", field1, field2,
> > field3, field4, field5) FROM '/home/johnf/agschgrid_data.sql'
> >
> > I always get "file not found".
>
> This form of COPY runs on the server, using the server's file access
> permissions.  Are you on the same machine that the Postgres server is
> on?  Do you have /home/johnf's permissions set so that the Postgres
> userid can read it?
>
> > I don't understand why pgadmin3 can't see my file?
>
> pgadmin3 is not involved in executing this command.
>
> There is probably some feature in pgadmin3 by which *it* can open the
> file and feed the data across the net to the server, but this command
> is not that.
>
>             regards, tom lane

Thanks to Tom I moved the file to "/tmp" a directory that Postgres has access
too.  Then the copy command worked perfectly from pgadmin3 1.6.3.



--
John Fabiani