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