[GENERAL] simple COPY FROM issue

[Kevin Duffy]

Hello All:

 

I am attempting to import data from a CSV file.

 

The command I am using is as follows:

    copy imagineoptions   from 'C:\\Options20081112.csv'   DELIMITERS
','  CSV ;

 

I get the following:

    WARNING:  nonstandard use of \\ in a string literal

     LINE 1: copy imagineoptions   from 'C:\\Options20081112.csv'
DELIM...

                                   ^

    HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.

 

    ERROR: could not open file "C:\Options20081112.csv" for reading: No
such file or directory

    SQL state: 58P01 

 

If I run DIR at the command prompt I get:

 

C:\>dir C:\Options20081112.csv

 Volume in drive C has no label.

 Volume Serial Number is 1824-0333

 

 Directory of C:\

 

11/12/2008  04:04 PM         1,300,220 Options20081112.csv

               1 File(s)      1,300,220 bytes

               0 Dir(s)  40,459,689,984 bytes free

 

C:\>

 

I have tried many variations of slashes and back-slashes, but nothing
works.

I am working within pgAdmin under Windows XP.

 

Please help me preserve my sanity.  I do not see that I am doing wrong.

But I am certain it is very simple.

 

Best Regards

 

 

Kevin Duffy