On Mon, Oct 25, 2010 at 5:54 PM, Marie-Claude QUIDOZ <marie-claude.qui...@cefe.cnrs.fr> wrote: > Hello > > I don't find how i can use the command "copy from" with pgadmin in sql > windows > > When i try to execute this command > "copy dico_coordonnee_geographique from 'C:/Dossier de > travail/Temporaire/dico_coordonnee" > > I receive this text > " ERREUR: n'a pas pu ouvrir le fichier "C:/Dossier de > travail/Temporaire/dico_coordonnee> pour une lecture : No such file or > directory
Are you really using COPY, or \COPY ? The latter is a client-side feature in psql, which won't work in pgAdmin. The former is a server-side copy, which should work in any interface, but requires the file to be on the server. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
