Hi Oisin, I am right in the condition you described, but nowadays the 8.0 documentation is only available without comments. I tried the way suggested by Richard Sydney-Smith (*eliminating the spaces in the path*), but unsuccessfully. Could you please help me? thanks, Fabio *hint from Richard Sydney-Smith* ( http://postgresql.1045698.n5.nabble.com/Windows-file-path-for-copy-tt1847135.html ): /Windows XP SP2 with Postgresql 8.0.3 Two commands on fails the other succeeds: *Fails *: select import_sharedata('C:\\Documents and Settings\\Richard\\Desktop\\EzyChart-20050721'); *Succeeds*: select import_sharedata('C:\\EzyChart-20050721'); / Oisin Glynn wrote: > > I have driven myself to distraction for the last 30 minutes trying to > get COPY to work on Windows XP. The Unix style c:/afolder/afile > instead of c:\afolder\afile was a desperation attempt. > > I had tried all sorts of double slashes \\ putting the whole path in > quotes basically all sorts of foolishness. [...] > Oisin > > > P.S. > I just discovered that the comments from 8.0 had the answer I was > looking for but these comments are not in the 8.1 docs. Should the > comments be rolled forward as new versions are created? Or if valid > comments added to the docs themselves? > > http://www.postgresql.org/docs/8.1/interactive/sql-copy.html > > http://www.postgresql.org/docs/8.0/interactive/sql-copy.html > > Now happily using COPY, > Oisin > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- View this message in context: http://postgresql.1045698.n5.nabble.com/GENERAL-COPY-command-documentation-tp1858906p4590548.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
