Postgres Pro
Downloads
Home   >   mailing lists

Re: using psql copy command - Mailing list pgsql-admin

From Tom Lane
Subject Re: using psql copy command
Date
Msg-id 12087.1099958493@sss.pgh.pa.us
Whole thread Raw
In response to using psql copy command  (David Bear <David.Bear@asu.edu>)
List pgsql-admin
Tree view 
David Bear <David.Bear@asu.edu> writes:
> npcenter=> \copy "contactName" from "/home/iddwb/data/copp/dev/npcenter/contactName.txt"
> "/home/iddwb/data/copp/dev/npcenter/contactName.txt": No such file or
> directory

> I must be missing something very obvious.. Help...

Use single quotes, or none at all, around the filename.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PERFORM] poor performance in migrated database
Next
From: Francisco Jose Bernabe Pellicer
Date:
Subject: Where is postgresql??