The file must be on the server. IIRC, with COPY FROM (as opposed to COPY
TO) the path can be relative to the server process dir but it's probably
a good idea to always use an absolute path.
If you wish to copy from the client machine you can use \copy within psql.
b
Kevin Duffy wrote:
Hello:
A follow up question that may clear this all up:
Is the 'filename' relative to the server machine or the client where
pgAdmin is running?
Kevin Duffy
WR Capital Management
40 Signal Rd
Stamford, CT
203-504-6221
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general