Re: problem with copy from on a windows system

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Marie-Claude QUIDOZ <Marie-Claude(dot)QUIDOZ(at)cefe(dot)cnrs(dot)fr>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: problem with copy from on a windows system
Date: 2010-10-27 10:40:13
Message-ID: 4CC8018D.3030902@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Le 27/10/2010 03:24, Marie-Claude QUIDOZ a écrit :
> [...]
> Yes, but both are on windows system
>

When you use the COPY command, the file you specify must be on the
PostgreSQL server. When you use \copy from psql, the file must be on the
computer where you execute the \copy command.

If you use the copy command, then the file wasn't available on the
server when you launched the copy command.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2010-10-27 10:42:17 Re: Feature request -- export as select into stmts
Previous Message Dave Page 2010-10-27 10:31:48 Re: problem with copy from on a windows system